APPS.PA_INVOICE_XFER dependencies on RA_CUSTOMER_TRX

Line 911: ra_customer_trx TRX,

907: INT_LINE.CONVERSION_RATE exchg_rate
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))

Line 963: -- from RA_CUSTOMER_TRX_LINES TRX

959: -- UPDATE RA_INTERFACE_LINES L
960: -- SET (L.AMOUNT,L.UNIT_SELLING_PRICE)
961: -- = ( SELECT sign(L.AMOUNT)*TRX.EXTENDED_AMOUNT,
962: -- sign(L.UNIT_SELLING_PRICE) *TRX.EXTENDED_AMOUNT
963: -- from RA_CUSTOMER_TRX_LINES TRX
964: -- Where TRX.CUSTOMER_TRX_ID
965: -- = cur_get_inv_info.CUST_TRX_ID
966: -- and ltrim(rtrim(TRX.INTERFACE_LINE_ATTRIBUTE6))
967: -- = ltrim(rtrim(L.INTERFACE_LINE_ATTRIBUTE6)))

Line 987: -- FROM RA_CUSTOMER_TRX_LINES_ALL TRX_LINES

983: --
984: -- /* Calculate the original Invoice amount in AR */
985: -- SELECT SUM(TRX_LINES.EXTENDED_AMOUNT)
986: -- INTO AR_ORIG_INV_AMT
987: -- FROM RA_CUSTOMER_TRX_LINES_ALL TRX_LINES
988: -- WHERE TRX_LINES.CUSTOMER_TRX_ID
989: -- = cur_get_inv_info.CUST_TRX_ID
990: -- AND TRX_LINES.INTERFACE_LINE_ATTRIBUTE1 = P_Project_Num
991: -- AND rtrim(ltrim(TRX_LINES.INTERFACE_LINE_ATTRIBUTE2))