DBA Data[Home] [Help]

APPS.CSD_INTERNAL_ORDERS_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 943: FROM oe_order_headers_all ooh,

939: ool.line_id,
940: ool.inventory_item_id,
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

Line 2088: FROM oe_order_headers_all

2084: source_document_type_id
2085: INTO l_customer_id,
2086: l_order_type_id,
2087: l_document_set_id
2088: FROM oe_order_headers_all
2089: WHERE header_id = p_order_header_id;
2090:
2091: -- get the defaults from picking rule.
2092: -- Auto pick confirm flag will be always set to N in this API

Line 2627: oe_order_headers_all oeh

2623:
2624: SELECT DISTINCT order_number
2625: BULK COLLECT INTO l_internal_orders_tbl
2626: FROM csd_product_transactions cpt,
2627: oe_order_headers_all oeh
2628: WHERE cpt.repair_line_id = p_repair_line_id
2629: AND cpt.order_header_id = oeh.header_id
2630: AND cpt.action_type IS NULL;
2631: