eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_CONFIG_ITEM_PK dependencies on OE_ORDER_HEADERS_ALL

Line 766: oe_order_headers_all oeh,

762: select wip_entity_id
763: into lWipEntityId
764: from wip_flow_schedules wfs,
765: oe_order_lines_all oel,
766: oe_order_headers_all oeh,
767: oe_transaction_types_all ota,
768: oe_transaction_types_tl otl,
769: mtl_sales_orders mso
770: where wfs.demand_source_line = oel.line_id --config line id

Line 825: oe_order_headers_all oeh,

821: select reservation_id
822: into lReserveId
823: from mtl_reservations mr,
824: oe_order_lines_all oel,
825: oe_order_headers_all oeh,
826: oe_transaction_types_all ota,
827: oe_transaction_types_tl otl,
828: mtl_sales_orders mso
829: where mr.demand_source_line_id = oel.line_id --config line id

Line 893: l_order_number OE_ORDER_HEADERS_ALL.order_number%TYPE;

889: -- The following flag is added by Renga Kannan on 03/13/2001
890:
891: l_resv_flag varchar2(1) := 'N';
892: pchgtype CTO_CHANGE_ORDER_PK.change_table_type;
893: l_order_number OE_ORDER_HEADERS_ALL.order_number%TYPE;
894: l_ml_mo_flag varchar2(1) := 'N';
895:
896: pAutoUnreserve varchar2(1);
897:

Line 937: oe_order_headers_all oeh,

933: CURSOR reservations IS
934: select distinct reservation_id
935: from mtl_reservations mr,
936: oe_order_lines_all oel,
937: oe_order_headers_all oeh,
938: oe_transaction_types_all ota,
939: oe_transaction_types_tl otl,
940: mtl_sales_orders mso
941: where mr.demand_source_line_id = oel.line_id --config line id

Line 1073: oe_order_headers_all oeh,

1069: into lSalesOrderId, --header id fro rsv api
1070: lOrgId, --ship from org id
1071: lHeaderId -- header id in oeh, for wip api
1072: from oe_order_lines_all oel,
1073: oe_order_headers_all oeh,
1074: oe_transaction_types_tl oet,
1075: mtl_sales_orders mso,
1076: mtl_system_items msi
1077: where oel.line_id = lConfigLineId

Line 1660: FROM OE_ORDER_HEADERS_ALL A,

1656: END IF;
1657: lStmtNumber := 600;
1658: SELECT Order_number
1659: INTO l_order_number
1660: FROM OE_ORDER_HEADERS_ALL A,
1661: OE_ORDER_LINES_ALL B
1662: WHERE B.line_id = pModelLineId
1663: AND A.Header_id = B.Header_Id;
1664:

Line 4494: oe_order_headers_all oeh

4490: lLineNum,
4491: lDeliveryNum,
4492: lOptionNum -- 2652379 : new variable
4493: from oe_order_lines_all oel,
4494: oe_order_headers_all oeh
4495: where oel.line_id = pLineId
4496: and oel.header_id = oeh.header_id;
4497:
4498: -- 2652379 Changed decode