DBA Data[Home] [Help]

APPS.FUN_INITIATOR_WF_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 1178: FROM ra_customer_trx_all rct,

1174:
1175: SELECT rct.trx_number invoice_number,
1176: rct.interface_header_attribute1 batch_id,
1177: rct.interface_header_attribute2 trx_id
1178: FROM ra_customer_trx_all rct,
1179: ra_batch_sources_all rbs
1180: WHERE rct.request_id=p_request_id
1181: AND rct.batch_source_id=rbs.batch_source_id
1182: AND NVL(rct.org_id, -99) =NVL(rbs.org_id, -99)

Line 1331: FROM RA_CUSTOMER_TRX_ALL RCT,

1327: BULK COLLECT INTO
1328: l_trx_header_type.attribute1,
1329: l_trx_header_type.attribute2,
1330: l_trx_header_type.invoice_number
1331: FROM RA_CUSTOMER_TRX_ALL RCT,
1332: RA_BATCH_SOURCES_ALL RBS
1333: WHERE RBS.name = (SELECT name FROM
1334: RA_BATCH_SOURCES_ALL WHERE BATCH_SOURCE_ID = 22 AND org_id = rct.org_id)
1335: AND RBS.batch_source_id = RCT.batch_source_id