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
25: AND rsl.po_header_id = poh.po_header_id
26: AND poh.vendor_id = x_vendor_id
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
44: AND rct.transaction_type = 'DELIVER'
56: SELECT rct.transaction_type trans_type,
57: rct.transaction_id trans_id,
58: rct.parent_transaction_id parent_trans_id,
59: rct.primary_quantity trans_qty
60: FROM rcv_transactions rct
61: WHERE rct.parent_transaction_id = std_rec.trans_id;
62:
63: child_rec child_details_c%rowtype;
64:
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
125: AND rsl.to_organization_id = x_to_org_id
132: SELECT rct.transaction_type trans_type,
133: rct.transaction_id trans_id,
134: rct.parent_transaction_id parent_trans_id,
135: rct.primary_quantity trans_qty
136: FROM rcv_transactions rct
137: WHERE rct.parent_transaction_id = int_rec.trans_id;
138:
139: child_rec child_details_c%rowtype;
140: