133: AR_SYSTEM_PARAMETERS AR,
134: HZ_CUST_ACCOUNTS BTCA,
135: HZ_CUST_SITE_USES BTCSU,
136: HZ_CUST_ACCT_SITES BTPS,
137: HR_ORGANIZATION_UNITS HR,
138: RA_CUSTOMER_TRX REL_T,
139: RA_CUST_TRX_TYPES REL_TT
140: WHERE T.customer_trx_id = p_customer_trx_id
141: AND T.invoice_currency_code = C.currency_code
387: SR_HRL.location_id -- poo_location_id
388: from RA_CUSTOMER_TRX TRX,
389: JTF_RS_SALESREPS SR,
390: PER_ALL_ASSIGNMENTS_F SR_PER,
391: HR_ORGANIZATION_UNITS SR_HRL
392: where TRX.customer_trx_id = ZXL.trx_id
393: and TRX.primary_salesrep_id IS NOT NULL
394: and TRX.primary_salesrep_id = SR.salesrep_id
395: and TRX.org_id = SR.org_id