APPS.POS_AP_INVOICES_PKG dependencies on RCV_SHIPMENT_LINES

Line 87: rcv_shipment_lines rsl

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
91: AND rsl.shipment_header_id = rsh.shipment_header_id

Line 98: rcv_shipment_lines rsl

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
102: AND rsl.shipment_header_id = rsh.shipment_header_id

Line 149: rcv_shipment_lines rsl

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
153: AND rsl.shipment_header_id = rsh.shipment_header_id

Line 160: rcv_shipment_lines rsl

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
164: AND rsl.shipment_header_id = rsh.shipment_header_id