APPS.ZX_JA_EXTRACT_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 414: AND EXISTS (SELECT 1 FROM ra_cust_trx_types_all types

410: DELETE
411: FROM zx_rep_trx_detail_t dtl
412: WHERE DTL.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
413: AND DTL.EXTRACT_SOURCE_LEDGER = 'AR'
414: AND EXISTS (SELECT 1 FROM ra_cust_trx_types_all types
415: WHERE types.org_id = dtl.internal_organization_id
416: AND dtl.trx_type_id = types.cust_trx_type_id
417: AND NVL(types.global_attribute1,'99') NOT IN ('31','32','33','34','35','36','37'));
418:

Line 1146: ra_cust_trx_types_all types

1142: sysdate,
1143: fnd_global.login_id,
1144: p_trl_global_variables_rec.request_id
1145: FROM zx_rep_trx_detail_t dtl,
1146: ra_cust_trx_types_all types
1147: WHERE dtl.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
1148: and dtl.extract_source_ledger = 'AR'
1149: and types.cust_trx_type_id = dtl.trx_type_id
1150: and types.org_id = dtl.internal_organization_id ;