APPS.CTO_WIP_UTIL dependencies on OE_ORDER_LINES_ALL

Line 62: oe_order_lines_all

58:
59: /*****************************************************************************
60: Procedure: insert_wip_interface
61: Parameters: p_model_line_id - line id of the configuration item in
62: oe_order_lines_all
63: p_wip_seq - group id to be used in interface table
64: x_error_message - error message if insert fails
65: x_message_name - name of error message if insert
66: fails

Line 141: from oe_order_lines_all oel

137: l_stmt_num := 100;
138:
139: select nvl(oel.dep_plan_required_flag, 'N')
140: into lDepPlanFlag
141: from oe_order_lines_all oel
142: where oel.line_id = p_line_id;
143:
144: --
145: -- Changes to support supply creation for partial qty

Line 171: oe_order_lines_all oel

167: -- added for 14157494: Begin -- Check if any routing is present for the line_id
168: SELECT count(1)
169: INTO l_routing_count
170: FROM bom_operational_routings bor,
171: oe_order_lines_all oel
172: WHERE oel.line_id = p_line_id
173: AND oel.INVENTORY_ITEM_ID = bor.assembly_item_id
174: AND oel.ship_from_org_id = bor.organization_id
175: AND ROWNUM = 1;

Line 195: oe_order_lines_all oel

191:
192: SELECT ENABLE_LOWER_LEVEL_SUPPLY
193: INTO l_mlsupply_parameter
194: FROM bom_parameters bp,
195: oe_order_lines_all oel
196: WHERE oel.line_id = p_line_id
197: AND oel.ship_from_org_id = bp.organization_id;
198:
199: IF PG_DEBUG <> 0 THEN

Line 342: oe_order_lines_all oel

338: from bom_calendar_dates cal,
339: mtl_parameters mp,
340: wip_parameters wp,
341: mtl_system_items msi,
342: oe_order_lines_all oel
343: where oel.line_id = p_line_id
344: and mp.organization_id = oel.ship_from_org_id
345: and wp.organization_id = mp.organization_id
346: and msi.organization_id = oel.ship_from_org_id

Line 427: oe_order_lines_all oel

423:
424: SELECT ENABLE_LOWER_LEVEL_SUPPLY
425: INTO l_mlsupply_parameter
426: FROM bom_parameters bp,
427: oe_order_lines_all oel
428: WHERE oel.line_id = p_line_id
429: AND oel.ship_from_org_id = bp.organization_id;
430:
431: IF (l_mlsupply_parameter in (2,3)) THEN --auto created config =2, auto created configs + ato items = 3

Line 571: oe_order_lines_all oel

567: from bom_calendar_dates cal,
568: mtl_parameters mp,
569: wip_parameters wp,
570: mtl_system_items msi,
571: oe_order_lines_all oel
572: where oel.line_id = p_line_id
573: and mp.organization_id = oel.ship_from_org_id
574: and wp.organization_id = mp.organization_id
575: and msi.organization_id = oel.ship_from_org_id

Line 698: from oe_order_lines_all oel,

694: l_eligible_line NUMBER := 0;
695: BEGIN
696: select 1
697: into l_eligible_line
698: from oe_order_lines_all oel,
699: mtl_customer_items mci
700: where oel.line_id = p_line_id
701: and oel.ordered_item_id = mci.customer_item_id (+)
702: and ((oel.item_identifier_type <> 'CUST')

Line 735: from oe_order_lines_all oel

731: BEGIN
732:
733: select 1
734: into l_eligible_line
735: from oe_order_lines_all oel
736: where exists (select 'Exists'
737: from WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
738: wsh_delivery_assignments wda,
739: mtl_customer_items mci

Line 787: from oe_order_lines_all oel,

783:
784: BEGIN
785: select 'IMPORTED'
786: into l_imported
787: from oe_order_lines_all oel,
788: WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
789: mtl_system_items msi --bugfix 2074290: added msi
790: where oel.line_id = p_line_id
791: and wdd.source_line_id = oel.line_id

Line 828: from oe_order_lines_all oel,

824: BEGIN
825:
826: select 'NOTASSIGNED'
827: into l_assigned
828: from oe_order_lines_all oel,
829: WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
830: wsh_delivery_assignments wda
831: where oel.line_id = p_line_id
832: and wdd.source_line_id = oel.line_id

Line 865: from oe_order_lines_all oel,

861: BEGIN
862:
863: select 'NOTPLANNED'
864: into l_planned
865: from oe_order_lines_all oel,
866: WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
867: wsh_delivery_assignments wda,
868: WSH_NEW_DELIVERIES_OB_GRP_V wnd
869: where oel.line_id = p_line_id