DBA Data[Home] [Help]

APPS.ARH_ADDR_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 2239: ra_customer_trx_lines_all ctl,

2235: into invoice_count
2236: from dual
2237: where exists ( select 'y'
2238: from ra_cust_trx_types_all ctt,
2239: ra_customer_trx_lines_all ctl,
2240: ra_customer_trx_all ct
2241: where ct.cust_trx_type_id = ctt.cust_trx_type_id
2242: and nvl(ct.org_id, -99) = nvl(ctt.org_id, -99)
2243: and ct.customer_trx_id = ctl.customer_trx_id

Line 2288: ra_customer_trx_lines_all ctl,

2284: into invoice_count
2285: from dual
2286: where exists ( select 'y'
2287: from ra_cust_trx_types_all ctt,
2288: ra_customer_trx_lines_all ctl,
2289: ra_customer_trx_all ct
2290: where ct.cust_trx_type_id = ctt.cust_trx_type_id
2291: and nvl(ct.org_id,-99) = nvl(ctt.org_id, -99)
2292: and ct.customer_trx_id = ctl.customer_trx_id