APPS.CTO_CONFIG_ITEM_PK dependencies on OE_ORDER_HEADERS_ALL

Line 691: oe_order_headers_all oeh,

687: select wip_entity_id
688: into lWipEntityId
689: from wip_flow_schedules wfs,
690: oe_order_lines_all oel,
691: oe_order_headers_all oeh,
692: oe_transaction_types_all ota,
693: oe_transaction_types_tl otl,
694: mtl_sales_orders mso
695: where wfs.demand_source_line = oel.line_id --config line id

Line 750: oe_order_headers_all oeh,

746: select reservation_id
747: into lReserveId
748: from mtl_reservations mr,
749: oe_order_lines_all oel,
750: oe_order_headers_all oeh,
751: oe_transaction_types_all ota,
752: oe_transaction_types_tl otl,
753: mtl_sales_orders mso
754: where mr.demand_source_line_id = oel.line_id --config line id

Line 818: l_order_number OE_ORDER_HEADERS_ALL.order_number%TYPE;

814: -- The following flag is added by Renga Kannan on 03/13/2001
815:
816: l_resv_flag varchar2(1) := 'N';
817: pchgtype CTO_CHANGE_ORDER_PK.change_table_type;
818: l_order_number OE_ORDER_HEADERS_ALL.order_number%TYPE;
819: l_ml_mo_flag varchar2(1) := 'N';
820:
821: pAutoUnreserve varchar2(1);
822:

Line 862: oe_order_headers_all oeh,

858: CURSOR reservations IS
859: select distinct reservation_id
860: from mtl_reservations mr,
861: oe_order_lines_all oel,
862: oe_order_headers_all oeh,
863: oe_transaction_types_all ota,
864: oe_transaction_types_tl otl,
865: mtl_sales_orders mso
866: where mr.demand_source_line_id = oel.line_id --config line id

Line 994: oe_order_headers_all oeh,

990: into lSalesOrderId, --header id fro rsv api
991: lOrgId, --ship from org id
992: lHeaderId -- header id in oeh, for wip api
993: from oe_order_lines_all oel,
994: oe_order_headers_all oeh,
995: oe_transaction_types_tl oet,
996: mtl_sales_orders mso,
997: mtl_system_items msi
998: where oel.line_id = lConfigLineId

Line 1568: FROM OE_ORDER_HEADERS_ALL A,

1564: END IF;
1565: lStmtNumber := 600;
1566: SELECT Order_number
1567: INTO l_order_number
1568: FROM OE_ORDER_HEADERS_ALL A,
1569: OE_ORDER_LINES_ALL B
1570: WHERE B.line_id = pModelLineId
1571: AND A.Header_id = B.Header_Id;
1572:

Line 4399: oe_order_headers_all oeh

4395: lLineNum,
4396: lDeliveryNum,
4397: lOptionNum -- 2652379 : new variable
4398: from oe_order_lines_all oel,
4399: oe_order_headers_all oeh
4400: where oel.line_id = pLineId
4401: and oel.header_id = oeh.header_id;
4402:
4403: -- 2652379 Changed decode