APPS.CTO_UPDATE_CONFIGS_PK dependencies on OE_ORDER_LINES_ALL

Line 208: from oe_order_lines_all oel

204: from bom_cto_order_lines_upg bcolu
205: where bcolu.config_item_id is not null
206: and not exists (
207: select 'exists'
208: from oe_order_lines_all oel
209: where oel.line_id = bcolu.line_id));
210: WriteToLog('Rows deleted from bcso_b::'|| sql%rowcount, 1);
211:
212: l_stmt_num := 15;

Line 328: from oe_order_lines_all oel,

324: and rownum = 1) -- bug 13876670
325: -- and not on open order lines
326: and not exists
327: (select 'exists'
328: from oe_order_lines_all oel,
329: bom_cto_order_lines bcol
330: where bcol.config_item_id = bac.config_item_id
331: and bcol.ato_line_id = oel.ato_line_id
332: and nvl(oel.open_flag, 'N') = 'Y'

Line 405: from oe_order_lines_all oel,

401: and rownum = 1 -- 13876670
402: )
403: and NOT EXISTS -- bug 13876670
404: (select 'exists'
405: from oe_order_lines_all oel,
406: bom_cto_order_lines bcol
407: where bcol.config_item_id = bac.config_item_id
408: and bcol.ato_line_id = oel.ato_line_id
409: and bcol.config_item_id = oel.inventory_item_id

Line 480: from oe_order_lines_all oel,

476: )
477: -- and not on open order lines
478: and not exists /* bug 3399310 sushant changed the query to identify config item exists */
479: (select 'exists'
480: from oe_order_lines_all oel,
481: bom_cto_order_lines bcol
482: where bcol.config_item_id = p_config_id
483: and bcol.line_id = oel.ato_line_id
484: and oel.item_type_code = 'CONFIG'

Line 1083: , oe_order_lines_all oel

1079: and mtl.organization_id = bcol2.ship_from_org_id
1080: and bcol2.ato_line_id in
1081: (select distinct bcol1.ato_line_id
1082: from bom_cto_order_lines bcol1
1083: , oe_order_lines_all oel
1084: , mtl_system_items msi
1085: -- for configs whose models have attr=2,3
1086: where bcol1.config_item_id is not null
1087: and bcol1.inventory_item_id = msi.inventory_item_id

Line 1182: , oe_order_lines_all oel

1178: , nvl(msi.config_orgs, '1')
1179: from bom_cto_order_lines bcol1
1180: , bom_cto_order_lines bcol2
1181: , bom_ato_configurations bac
1182: , oe_order_lines_all oel
1183: , mtl_system_items msi
1184: -- base model has item attr = 3
1185: where bac.base_model_id = msi.inventory_item_id
1186: and bac.organization_id = msi.organization_id

Line 1451: , oe_order_lines_all oel

1447: , bcol.QTY_PER_PARENT_MODEL
1448: , 'UPG' --STATUS
1449: , nvl(msi.CONFIG_ORGS, '1')
1450: from bom_cto_order_lines bcol
1451: , oe_order_lines_all oel
1452: , mtl_system_items msi
1453: -- select all configs on open order lines
1454: where bcol.ato_line_id = oel.ato_line_id
1455: and oel.open_flag = 'Y' -- bug 13362916 removed NVL

Line 1547: , oe_order_lines_all oel

1543: , nvl(msi.CONFIG_ORGS, '1')
1544: from bom_cto_order_lines bcol1
1545: , bom_cto_order_lines bcol2
1546: , bom_ato_configurations bac
1547: , oe_order_lines_all oel
1548: , mtl_system_items msi
1549: -- base model has item attr = 3
1550: where bac.base_model_id = msi.inventory_item_id
1551: and bac.organization_id = msi.organization_id

Line 1940: , oe_order_lines_all oel

1936: --, bcol2.SEQUENCE
1937: , nvl(msi.config_orgs, '1')
1938: from bom_cto_order_lines bcol1
1939: , bom_cto_order_lines bcol2
1940: , oe_order_lines_all oel
1941: , mtl_system_items msi
1942: , mtl_item_categories mcat
1943: -- select entire configuration
1944: where bcol2.ato_line_id = bcol1.ato_line_id

Line 2048: , oe_order_lines_all oel

2044: , nvl(msi.config_orgs, '1')
2045: from bom_cto_order_lines bcol1
2046: , bom_cto_order_lines bcol2
2047: , bom_ato_configurations bac
2048: , oe_order_lines_all oel
2049: , mtl_system_items msi
2050: , mtl_item_categories mcat
2051: -- base model has item attr = 3
2052: where bac.base_model_id = msi.inventory_item_id

Line 2313: , oe_order_lines_all oel

2309: , 'UPG' --STATUS
2310: --, bcol.SEQUENCE
2311: , nvl(msi2.CONFIG_ORGS, '1')
2312: from bom_cto_order_lines bcol
2313: , oe_order_lines_all oel
2314: , mtl_system_items msi2
2315: -- select all configs on open order lines
2316: where bcol.ato_line_id = oel.ato_line_id
2317: and bcol.inventory_item_id = msi2.inventory_item_id

Line 2426: , oe_order_lines_all oel

2422: , nvl(msi.CONFIG_ORGS, '1')
2423: from bom_cto_order_lines bcol1
2424: , bom_cto_order_lines bcol2
2425: , bom_ato_configurations bac
2426: , oe_order_lines_all oel
2427: , mtl_system_items msi
2428: , mtl_item_categories mcat
2429: -- base model has item attr = 3
2430: where bac.base_model_id = msi.inventory_item_id

Line 2784: , oe_order_lines_all oel

2780: --, bcol2.SEQUENCE
2781: , nvl(msi.config_orgs, '1')
2782: from bom_cto_order_lines bcol1
2783: , bom_cto_order_lines bcol2
2784: , oe_order_lines_all oel
2785: , mtl_system_items msi
2786: , oe_order_lines_all oel2 --bugfix 3371155
2787: -- select entire configuration
2788: where bcol2.ato_line_id = bcol1.ato_line_id

Line 2786: , oe_order_lines_all oel2 --bugfix 3371155

2782: from bom_cto_order_lines bcol1
2783: , bom_cto_order_lines bcol2
2784: , oe_order_lines_all oel
2785: , mtl_system_items msi
2786: , oe_order_lines_all oel2 --bugfix 3371155
2787: -- select entire configuration
2788: where bcol2.ato_line_id = bcol1.ato_line_id
2789: -- to get item attribute
2790: and msi.inventory_item_id = bcol2.inventory_item_id

Line 2894: , oe_order_lines_all oel

2890: , nvl(msi.config_orgs, '1')
2891: from bom_cto_order_lines bcol1
2892: , bom_cto_order_lines bcol2
2893: , bom_ato_configurations bac
2894: , oe_order_lines_all oel
2895: , mtl_system_items msi
2896: where bac.config_item_id = p_config_id
2897: -- and exists in bcol
2898: and bac.config_item_id = bcol1.config_item_id

Line 4042: oe_order_lines_all oel,

4038: oeh.order_number,
4039: decode(bcolu.status, 'MRP_SRC', 'was successfully processed', 'errored out') status
4040: from bom_cto_order_lines_upg bcolu,
4041: mtl_system_items_kfv msi,
4042: oe_order_lines_all oel,
4043: oe_order_headers_all oeh
4044: where bcolu.config_item_id is not null
4045: and bcolu.config_item_id = msi.inventory_item_id
4046: and bcolu.ship_from_org_id = msi.organization_id