[Home] [Help]
479: -1 * l_retained_amount
480: FROM ap_invoice_distributions aid,
481: po_distributions pd,
482: po_line_locations pll,
483: rcv_transactions rtxn -- bug 5443250
484: WHERE aid.invoice_distribution_id = l_invoice_distribution_id
485: AND pd.po_distribution_id = aid.po_distribution_id
486: AND pll.line_location_id = pd.line_location_id
487: AND rtxn.po_line_location_id = pll.line_location_id
542: l_retained_amount,
543: -1 * l_retained_amount
544: FROM ap_invoice_lines ail1,
545: po_line_locations pll,
546: rcv_transactions rtxn -- bug 5443250
547: WHERE ail1.invoice_id = x_invoice_id
548: AND ail1.line_number =x_invoice_line_number
549: AND pll.line_location_id = ail1.po_line_location_id
550: AND rtxn.po_line_location_id = pll.line_location_id
930: DECODE(PD.destination_type_code,
931: 'EXPENSE', PD.award_id), --award_id
932: ap_invoice_distributions_s.nextval
933: FROM po_distributions_ap_v PD,
934: rcv_transactions RT
935: WHERE PD.line_location_id = x_po_line_location_id
936: and Pd.line_location_id = RT.po_line_location_id
937: and RT.TRANSACTION_ID= X_Rcv_Transaction_Id ;
938:
1755:
1756: l_debug_info := 'Call RCV api to update amount/quantity billed on the
1757: rcv_transaction';
1758:
1759: RCV_BILL_UPDATING_SV.ap_update_rcv_transactions(
1760: X_rcv_transaction_id => x_rcv_transaction_id,
1761: X_quantity_billed => Null,
1762: X_uom_lookup_code => x_uom_lookup_code,
1763: X_amount_billed => x_match_amount,
2147: FROM PO_DISTRIBUTIONS_AP_V PD,
2148: MTL_SYSTEM_ITEMS MSI,
2149: PO_AP_RECEIPT_MATCH_V RCV,
2150: RCV_SHIPMENT_LINES RSL,
2151: RCV_TRANSACTIONS RT --7015553
2152: WHERE RCV.RCV_TRANSACTION_ID = X_RCV_TRANSACTION_ID
2153: AND RCV.PO_LINE_LOCATION_ID = PD.LINE_LOCATION_ID
2154: AND RSL.SHIPMENT_LINE_ID = RCV.RCV_SHIPMENT_LINE_ID
2155: AND PD.PO_DISTRIBUTION_ID = NVL(X_PO_DISTRIBUTION_ID,PD.PO_DISTRIBUTION_ID)