PS Query question - In List Prompt
I tired below
1. Created and prompts (:4) no field attached to it no prompt table, I called it filler
2. Using the prompt that I created in step 1, I created an Expression that has A.BUSINESS_UNIT_GL_IN (:4) AND 'A'
3. On the Criteria tab, Expression 1 has A.BUSINESS_UNIT_GL IN (:4) AND 'A' Operator is equal to and Expression 2 has A
The SQL looks like below
SELECT B.BUSINESS_UNIT, B.INVOICE, B.BILL_TO_CUST_ID, D.NAME1, C.SOLD_TO_CUST_ID, E.NAME2, C.IDENTIFIER, C.DESCR, C.GROSS_EXTENDED_AMT, TO_CHAR(C.CHARGE_FROM_DT,'YYYY-MM-DD'), TO_CHAR(C.CHARGE_TO_DT,'YYYY-MM-DD'), A.ACCT_ENTRY_TYPE, TO_CHAR(A.ACCOUNTING_DT,'YYYY-MM-DD'), A.FISCAL_YEAR, A.ACCOUNTING_PERIOD, A.ACCOUNT, A.DEPTID, A.PROGRAM_CODE, A.MONETARY_AMOUNT, TO_CHAR(SYSDATE,'YYYY-MM-DD'),D.SETID,D.CUST_ID