APPS.ZX_JA_EXTRACT_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 260: ra_customer_trx_all rct

256: WHERE DET.REQUEST_ID = '||P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID||' and
257: NOT EXISTS
258: (
259: SELECT 1 FROM ra_batch_sources_all rbs,
260: ra_customer_trx_all rct
261: WHERE
262: rbs.batch_source_id = DET.TRX_BATCH_SOURCE_ID and
263: rct.batch_source_id = rbs.batch_source_id and
264: /* selecting trx with GUI TYPE 31,32,35,36,37 */

Line 332: RA_CUSTOMER_TRX_ALL rct,

328: WHERE DET.REQUEST_ID = '||P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID||' and
329: NOT EXISTS
330: (SELECT 1
331: FROM
332: RA_CUSTOMER_TRX_ALL rct,
333: JA_LOOKUPS ja1,
334: JA_LOOKUPS ja2,
335: JA_LOOKUPS ja3
336: WHERE

Line 2430: FROM ra_customer_trx_all rct,

2426:
2427: IF P_TRX_SOURCE_ID is not null THEN
2428: SELECT rct_org.trx_number
2429: INTO X_ORG_TRX_NUMBER
2430: FROM ra_customer_trx_all rct,
2431: ra_customer_trx_all rct_org,
2432: ra_batcH_sources_all rbs
2433: WHERE rct_org.customer_Trx_id = rct.previous_customer_trx_id and
2434: rct.batch_source_id = rbs.batch_source_id and

Line 2431: ra_customer_trx_all rct_org,

2427: IF P_TRX_SOURCE_ID is not null THEN
2428: SELECT rct_org.trx_number
2429: INTO X_ORG_TRX_NUMBER
2430: FROM ra_customer_trx_all rct,
2431: ra_customer_trx_all rct_org,
2432: ra_batcH_sources_all rbs
2433: WHERE rct_org.customer_Trx_id = rct.previous_customer_trx_id and
2434: rct.batch_source_id = rbs.batch_source_id and
2435: rbs.batch_source_id = P_TRX_SOURCE_ID and

Line 2522: ra_customer_trx_all rct

2518: X_GDF_RA_CUST_TRX_ATT6,
2519: X_GDF_RA_CUST_TRX_ATT7,
2520: X_GDF_RA_CUST_TRX_ATT8
2521: FROM
2522: ra_customer_trx_all rct
2523: WHERE
2524: rct.customer_trx_id = P_TRX_ID and
2525: rct.global_attribute_category = 'JA.TW.ARXTWMAI.RA_CUSTOMER_TRX';
2526: