Message:
: Hello, : I was looking at some of the report which i am supposed to customize. I didn't understand the purpose of having the '&' clause before the column name at the select statement itself as well as at the where clause. : The code looks as below, thanks in advance : SELECT : &PAGEBREAK_SEGMENT PAGEBREAK_SEGMENT_H, : &ACCOUNTING_SEGMENT ACCOUNTING_SEGMENT_H, : &FLEXDATA FLEXDATA_H, : &BEG_BAL BEG_BAL_H, : &ACTIVITY ACTIVITY_H, : &END_BAL END_BAL_H : FROM : GL_BALANCES GLB, : GL_CODE_COMBINATIONS GLCC : WHERE : GLB.ACTUAL_FLAG = 'A' : AND GLB.SET_OF_BOOKS_ID = &P_SET_OF_BOOKS_ID : AND GLB.CURRENCY_CODE = :P_CURRENCY_CODE : AND &CURRENCY_WHERE : AND &PERIOD_WHERE : AND GLB.CODE_COMBINATION_ID = GLCC.CODE_COMBINATION_ID : AND GLCC.CHART_OF_ACCOUNTS_ID = :STRUCT_NUM : AND GLCC.TEMPLATE_ID IS NULL : AND &PAGEBREAK_WHERE : &GROUPORDER