[Home] [Help]
140: be the id of the RECEIVE transaction)
141: p_rts_txn_id : The transaction_id of the RETURN (RTS) Trasnaction itself
142: p_po_dist_id : If the Return is done against a delivery and the
143: po_distribution_id is known. If this is null, the quantity
144: will be prorated across the po distributions.
145: p_quantity : The quantity returned. Please note that the quantity should be
146: in the same UOM as the Receive Transaction, because we are
147: matching against that transaction. The quantity should be
148: negative.
315: Begin
316: Select 'Y'
317: Into l_invoice_exists
318: From ap_invoice_distributions aid,
319: po_distributions pd,
320: po_line_locations pll
321: where aid.po_distribution_id = pd.po_distribution_id
322: and pd.line_location_id = pll.line_location_id
323: and pll.line_location_id = l_po_shipment_id
852: --Bugfix:5395955
853: IF (p_po_dist_id IS NOT NULL) THEN
854: SELECT code_combination_id
855: INTO p_po_ccid
856: FROM po_distributions_ap_v
857: WHERE po_distribution_id = p_po_dist_id;
858: END IF;
859:
860: Exception
998: INTO l_invoice_exists
999: FROM ap_invoice_distributions aid,
1000: rcv_shipment_headers rsh,
1001: rcv_transactions rct,
1002: po_distributions pod
1003: WHERE aid.po_distribution_id = pod.po_distribution_id
1004: AND pod.line_location_id = rct.po_line_location_id
1005: AND rsh.shipment_header_id = rct.shipment_header_id
1006: AND rsh.receipt_num = p_receipt_num