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 2503: FROM ra_customer_trx_all rct,

2499:
2500: IF P_TRX_SOURCE_ID is not null THEN
2501: SELECT rct_org.trx_number
2502: INTO X_ORG_TRX_NUMBER
2503: FROM ra_customer_trx_all rct,
2504: ra_customer_trx_all rct_org,
2505: ra_batcH_sources_all rbs
2506: WHERE rct_org.customer_Trx_id = rct.previous_customer_trx_id and
2507: rct.batch_source_id = rbs.batch_source_id and

Line 2504: ra_customer_trx_all rct_org,

2500: IF P_TRX_SOURCE_ID is not null THEN
2501: SELECT rct_org.trx_number
2502: INTO X_ORG_TRX_NUMBER
2503: FROM ra_customer_trx_all rct,
2504: ra_customer_trx_all rct_org,
2505: ra_batcH_sources_all rbs
2506: WHERE rct_org.customer_Trx_id = rct.previous_customer_trx_id and
2507: rct.batch_source_id = rbs.batch_source_id and
2508: rbs.batch_source_id = P_TRX_SOURCE_ID and

Line 2595: ra_customer_trx_all rct

2591: X_GDF_RA_CUST_TRX_ATT6,
2592: X_GDF_RA_CUST_TRX_ATT7,
2593: X_GDF_RA_CUST_TRX_ATT8
2594: FROM
2595: ra_customer_trx_all rct
2596: WHERE
2597: rct.customer_trx_id = P_TRX_ID and
2598: rct.global_attribute_category = 'JA.TW.ARXTWMAI.RA_CUSTOMER_TRX';
2599: