DBA Data[Home] [Help]

APPS.PA_INVOICE_XFER dependencies on RA_BATCH_SOURCES

Line 453: RA_BATCH_SOURCES RBS,PA_IMPLEMENTATIONS IMP

449: AND I.TRX_NUMBER = P_Trx_Num ;
450:
451: /*Commented for bug 1858443. Added for bug 1529404
452: AND I.BATCH_SOURCE_NAME = (SELECT RBS.NAME FROM
453: RA_BATCH_SOURCES RBS,PA_IMPLEMENTATIONS IMP
454: WHERE RBS.BATCH_SOURCE_ID
455: =IMP.INVOICE_BATCH_SOURCE_ID);
456: */
457:

Line 912: ra_batch_sources SOURCE

908: FROM ra_interface_lines INT_LINE,
909: pa_draft_invoices CM_DI,
910: pa_draft_invoices ORG_DI,
911: ra_customer_trx TRX,
912: ra_batch_sources SOURCE
913: WHERE INT_LINE.interface_line_attribute1 = P_Project_Num
914: AND CM_DI.request_id = P_Request_Id
915: AND ltrim(rtrim(INT_LINE.interface_line_attribute2))
916: = ltrim(rtrim(to_char(CM_DI.Draft_invoice_num)))