[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.
322: Begin
323: Select 'Y'
324: Into l_invoice_exists
325: From ap_invoice_distributions aid,
326: po_distributions pd,
327: po_line_locations pll
328: where aid.po_distribution_id = pd.po_distribution_id
329: and pd.line_location_id = pll.line_location_id
330: and pll.line_location_id = l_po_shipment_id
923: --Bugfix:5395955
924: IF (p_po_dist_id IS NOT NULL) THEN
925: SELECT code_combination_id
926: INTO p_po_ccid
927: FROM po_distributions_ap_v
928: WHERE po_distribution_id = p_po_dist_id;
929: END IF;
930:
931: Exception
1070: INTO l_invoice_exists
1071: FROM ap_invoice_distributions aid,
1072: rcv_shipment_headers rsh,
1073: rcv_transactions rct,
1074: po_distributions pod
1075: WHERE aid.po_distribution_id = pod.po_distribution_id
1076: AND pod.line_location_id = rct.po_line_location_id
1077: AND rsh.shipment_header_id = rct.shipment_header_id
1078: AND rsh.receipt_num = p_receipt_num