APPS.POS_AP_INVOICES_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 86: rcv_shipment_headers rsh,

82: CURSOR packing_slip_cursor IS
83: select DISTINCT RSH.PACKING_SLIP packing_slip
84: FROM ap_invoice_distributions_all aid,
85: po_distributions_all pd,
86: rcv_shipment_headers rsh,
87: rcv_shipment_lines rsl
88: WHERE aid.invoice_id = l_invoice_id
89: AND aid.po_distribution_id = pd.po_distribution_id
90: AND pd.LINE_LOCATION_ID = rsl.po_line_location_id

Line 97: rcv_shipment_headers rsh,

93: union
94: select DISTINCT RSL.PACKING_SLIP packing_slip
95: FROM ap_invoice_distributions_all aid,
96: po_distributions_all pd,
97: rcv_shipment_headers rsh,
98: rcv_shipment_lines rsl
99: WHERE aid.invoice_id = l_invoice_id
100: AND aid.po_distribution_id = pd.po_distribution_id
101: AND pd.LINE_LOCATION_ID = rsl.po_line_location_id

Line 148: rcv_shipment_headers rsh,

144: CURSOR packing_slip_cursor IS
145: select DISTINCT RSH.PACKING_SLIP packing_slip
146: FROM ap_invoice_distributions_all aid,
147: po_distributions_all pd,
148: rcv_shipment_headers rsh,
149: rcv_shipment_lines rsl
150: WHERE aid.invoice_id = l_invoice_id
151: AND aid.po_distribution_id = pd.po_distribution_id
152: AND pd.LINE_LOCATION_ID = rsl.po_line_location_id

Line 159: rcv_shipment_headers rsh,

155: union
156: select DISTINCT RSL.PACKING_SLIP packing_slip
157: FROM ap_invoice_distributions_all aid,
158: po_distributions_all pd,
159: rcv_shipment_headers rsh,
160: rcv_shipment_lines rsl
161: WHERE aid.invoice_id = l_invoice_id
162: AND aid.po_distribution_id = pd.po_distribution_id
163: AND pd.LINE_LOCATION_ID = rsl.po_line_location_id

Line 329: rcv_shipment_headers rsh

325: --using lines for matching
326: select distinct rsh.receipt_num, rsh.SHIPMENT_HEADER_ID
327: from ap_invoice_lines_all al,
328: rcv_transactions rt,
329: rcv_shipment_headers rsh
330: where al.invoice_id = l_invoice_id
331: and al.rcv_transaction_id = rt.transaction_id
332: and rt.SHIPMENT_HEADER_ID = rsh.SHIPMENT_HEADER_ID;
333:

Line 338: rcv_shipment_headers rsh

334: --using distributions for matching
335: /* SELECT distinct rsh.SHIPMENT_HEADER_ID, rsh.receipt_num
336: FROM ap_invoice_distributions_all aid,
337: rcv_transactions rt,
338: rcv_shipment_headers rsh
339: WHERE aid.invoice_id = l_invoice_id
340: and aid.rcv_transaction_id = rt.transaction_id
341: and rt.SHIPMENT_HEADER_ID = rsh.SHIPMENT_HEADER_ID;
342: */