APPS.RCV_GET_DELIVERED_QTY dependencies on RCV_SHIPMENT_LINES

Line 20: FROM rcv_shipment_lines rsl,

16: SELECT rct.transaction_type trans_type,
17: rct.transaction_id trans_id,
18: rct.parent_transaction_id parent_trans_id,
19: rct.primary_quantity trans_qty
20: FROM rcv_shipment_lines rsl,
21: po_headers_all poh,
22: rcv_transactions rct
23: WHERE rct.source_document_code = 'PO'
24: AND rsl.item_id = x_item_id

Line 39: FROM rcv_shipment_lines rsl,

35: SELECT rct.transaction_type trans_type,
36: rct.transaction_id trans_id,
37: rct.parent_transaction_id parent_trans_id,
38: rct.primary_quantity trans_qty
39: FROM rcv_shipment_lines rsl,
40: rcv_transactions rct
41: WHERE rct.source_document_code = 'PO'
42: AND rsl.item_id = x_item_id
43: AND rct.shipment_line_id = rsl.shipment_line_id

Line 120: FROM rcv_shipment_lines rsl,

116: SELECT rct.transaction_type trans_type,
117: rct.transaction_id trans_id,
118: rct.parent_transaction_id parent_trans_id,
119: rct.primary_quantity trans_qty
120: FROM rcv_shipment_lines rsl,
121: rcv_transactions rct
122: WHERE rct.shipment_line_id = rsl.shipment_line_id
123: AND rsl.item_id = x_item_id
124: AND rsl.from_organization_id = x_from_org_id

Line 189: FROM rcv_shipment_lines rsl

185: begin
186:
187: SELECT count(*)
188: INTO x_rec_not_del_qty
189: FROM rcv_shipment_lines rsl
190: , mtl_supply ms
191: WHERE rsl.SHIPMENT_LINE_ID = ms.SHIPMENT_LINE_ID
192: AND rsl.SHIPMENT_HEADER_ID = ms.SHIPMENT_HEADER_ID
193: AND rsl.FROM_ORGANIZATION_ID = x_from_org_id