149: AR_SYSTEM_PARAMETERS AR,
150: HZ_CUST_ACCOUNTS BTCA,
151: HZ_CUST_SITE_USES BTCSU,
152: HZ_CUST_ACCT_SITES BTPS,
153: HR_ORGANIZATION_UNITS HR,
154: RA_CUSTOMER_TRX REL_T,
155: RA_CUST_TRX_TYPES REL_TT
156: WHERE T.request_id = p_request_id
157: AND T.invoice_currency_code = C.currency_code
418: SR_HRL.location_id -- poo_location_id
419: from RA_CUSTOMER_TRX TRX,
420: JTF_RS_SALESREPS SR,
421: PER_ALL_ASSIGNMENTS_F SR_PER,
422: HR_ORGANIZATION_UNITS SR_HRL
423: where TRX.customer_trx_id = ZXL.trx_id
424: and TRX.primary_salesrep_id IS NOT NULL
425: and TRX.primary_salesrep_id = SR.salesrep_id
426: and TRX.org_id = SR.org_id