APPS.CSD_INTERNAL_ORDERS_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 74: FROM csd_product_transactions cpt, po_requisition_lines_all prl

70: -- 1. Get the requisition line id and from org information.
71: SELECT cpt.ship_from_org,prl.requisition_line_id,prl.deliver_to_location_id,
72: NVL(p_receiving_subinv,l_subinventory)
73: INTO l_from_org,l_requisition_line_id,l_deliver_to_location_id,l_subinventory
74: FROM csd_product_transactions cpt, po_requisition_lines_all prl
75: WHERE cpt.product_transaction_id = p_product_txn_id
76: AND cpt.req_header_id = prl.requisition_header_id
77: AND NVL(cpt.req_line_id,prl.requisition_line_id) = prl.requisition_line_id;
78:

Line 945: po_requisition_lines_all pol,

941: pol.requisition_line_id,
942: wdd.delivery_detail_id
943: FROM oe_order_headers_all ooh,
944: oe_order_lines_all ool,
945: po_requisition_lines_all pol,
946: wsh_delivery_details wdd
947: WHERE ooh.orig_sys_document_ref = x_requisition_number
948: AND ooh.source_document_id = x_requisition_id
949: AND ooh.header_id = ool.header_id

Line 1827: po_requisition_lines_all prl,

1823: BEGIN
1824: SELECT SUM(rt.quantity)
1825: INTO l_received_quantity
1826: FROM csd_product_transactions cpt,
1827: po_requisition_lines_all prl,
1828: rcv_shipment_headers rsh,
1829: rcv_shipment_lines rsl,
1830: rcv_transactions rt
1831: WHERE cpt.product_transaction_id = p_product_txn_id