APPS.ARH_ADDR_PKG dependencies on RA_CUSTOMER_TRX

Line 2080: ra_customer_trx_lines ctl,

2076: into invoice_count
2077: from dual
2078: where exists ( select 'y'
2079: from ra_cust_trx_types ctt,
2080: ra_customer_trx_lines ctl,
2081: ra_customer_trx ct
2082: where ct.cust_trx_type_id = ctt.cust_trx_type_id
2083: and ct.customer_trx_id = ctl.customer_trx_id
2084: and 'TAX' = ctl.line_type

Line 2081: ra_customer_trx ct

2077: from dual
2078: where exists ( select 'y'
2079: from ra_cust_trx_types ctt,
2080: ra_customer_trx_lines ctl,
2081: ra_customer_trx ct
2082: where ct.cust_trx_type_id = ctt.cust_trx_type_id
2083: and ct.customer_trx_id = ctl.customer_trx_id
2084: and 'TAX' = ctl.line_type
2085: and (

Line 2120: ra_customer_trx_lines ctl,

2116: into invoice_count
2117: from dual
2118: where exists ( select 'y'
2119: from ra_cust_trx_types ctt,
2120: ra_customer_trx_lines ctl,
2121: ra_customer_trx ct
2122: where ct.cust_trx_type_id = ctt.cust_trx_type_id
2123: and ct.customer_trx_id = ctl.customer_trx_id
2124: and 'TAX' = ctl.line_type

Line 2121: ra_customer_trx ct

2117: from dual
2118: where exists ( select 'y'
2119: from ra_cust_trx_types ctt,
2120: ra_customer_trx_lines ctl,
2121: ra_customer_trx ct
2122: where ct.cust_trx_type_id = ctt.cust_trx_type_id
2123: and ct.customer_trx_id = ctl.customer_trx_id
2124: and 'TAX' = ctl.line_type
2125: and (

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 2240: ra_customer_trx_all ct

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
2244: and 'TAX' = ctl.line_type

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

Line 2289: ra_customer_trx_all ct

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
2293: and 'TAX' = ctl.line_type