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 181: oe_order_lines_all oel

177:
178: SELECT ENABLE_LOWER_LEVEL_SUPPLY
179: INTO l_mlsupply_parameter
180: FROM bom_parameters bp,
181: oe_order_lines_all oel
182: WHERE oel.line_id = p_line_id
183: AND oel.ship_from_org_id = bp.organization_id;
184:
185: IF PG_DEBUG <> 0 THEN

Line 326: oe_order_lines_all oel

322: from bom_calendar_dates cal,
323: mtl_parameters mp,
324: wip_parameters wp,
325: mtl_system_items msi,
326: oe_order_lines_all oel
327: where oel.line_id = p_line_id
328: and mp.organization_id = oel.ship_from_org_id
329: and wp.organization_id = mp.organization_id
330: and msi.organization_id = oel.ship_from_org_id

Line 411: oe_order_lines_all oel

407:
408: SELECT ENABLE_LOWER_LEVEL_SUPPLY
409: INTO l_mlsupply_parameter
410: FROM bom_parameters bp,
411: oe_order_lines_all oel
412: WHERE oel.line_id = p_line_id
413: AND oel.ship_from_org_id = bp.organization_id;
414:
415: IF (l_mlsupply_parameter in (2,3)) THEN --auto created config =2, auto created configs + ato items = 3

Line 553: oe_order_lines_all oel

549: from bom_calendar_dates cal,
550: mtl_parameters mp,
551: wip_parameters wp,
552: mtl_system_items msi,
553: oe_order_lines_all oel
554: where oel.line_id = p_line_id
555: and mp.organization_id = oel.ship_from_org_id
556: and wp.organization_id = mp.organization_id
557: and msi.organization_id = oel.ship_from_org_id

Line 680: from oe_order_lines_all oel,

676: l_eligible_line NUMBER := 0;
677: BEGIN
678: select 1
679: into l_eligible_line
680: from oe_order_lines_all oel,
681: mtl_customer_items mci
682: where oel.line_id = p_line_id
683: and oel.ordered_item_id = mci.customer_item_id (+)
684: and ((oel.item_identifier_type <> 'CUST')

Line 717: from oe_order_lines_all oel

713: BEGIN
714:
715: select 1
716: into l_eligible_line
717: from oe_order_lines_all oel
718: where exists (select 'Exists'
719: from WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
720: wsh_delivery_assignments wda,
721: mtl_customer_items mci

Line 769: from oe_order_lines_all oel,

765:
766: BEGIN
767: select 'IMPORTED'
768: into l_imported
769: from oe_order_lines_all oel,
770: WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
771: mtl_system_items msi --bugfix 2074290: added msi
772: where oel.line_id = p_line_id
773: and wdd.source_line_id = oel.line_id

Line 810: from oe_order_lines_all oel,

806: BEGIN
807:
808: select 'NOTASSIGNED'
809: into l_assigned
810: from oe_order_lines_all oel,
811: WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
812: wsh_delivery_assignments wda
813: where oel.line_id = p_line_id
814: and wdd.source_line_id = oel.line_id

Line 847: from oe_order_lines_all oel,

843: BEGIN
844:
845: select 'NOTPLANNED'
846: into l_planned
847: from oe_order_lines_all oel,
848: WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
849: wsh_delivery_assignments wda,
850: WSH_NEW_DELIVERIES_OB_GRP_V wnd
851: where oel.line_id = p_line_id