APPS.CTO_UPDATE_CONFIGS_PK dependencies on OE_ORDER_LINES_ALL

Line 189: from oe_order_lines_all oel

185: from bom_cto_order_lines_upg bcolu
186: where bcolu.config_item_id is not null
187: and not exists (
188: select 'exists'
189: from oe_order_lines_all oel
190: where oel.line_id = bcolu.line_id));
191: WriteToLog('Rows deleted from bcso_b::'|| sql%rowcount, 1);
192:
193: l_stmt_num := 15;

Line 303: from oe_order_lines_all oel,

299: where bcolu.config_item_id = bac.config_item_id)
300: -- and not on open order lines
301: and not exists
302: (select 'exists'
303: from oe_order_lines_all oel,
304: bom_cto_order_lines bcol
305: where bcol.config_item_id = bac.config_item_id
306: and bcol.ato_line_id = oel.ato_line_id
307: and nvl(oel.open_flag, 'N') = 'Y'

Line 370: from oe_order_lines_all oel,

366: where bcolu.config_item_id = bac.config_item_id
367: )
368: and bac.config_item_id not in
369: (select nvl( bcol.config_item_id,-1)
370: from oe_order_lines_all oel,
371: bom_cto_order_lines bcol
372: where bcol.ato_line_id = oel.ato_line_id
373: and oel.item_type_code = 'CONFIG'
374: and open_flag = 'Y'

Line 431: from oe_order_lines_all oel,

427: where bcolu.config_item_id = p_config_id)
428: -- and not on open order lines
429: and not exists /* bug 3399310 sushant changed the query to identify config item exists */
430: (select 'exists'
431: from oe_order_lines_all oel,
432: bom_cto_order_lines bcol
433: where bcol.config_item_id = p_config_id
434: and bcol.line_id = oel.ato_line_id
435: and oel.item_type_code = 'CONFIG'

Line 895: , oe_order_lines_all oel

891: and mtl.organization_id = bcol2.ship_from_org_id
892: and bcol2.ato_line_id in
893: (select distinct bcol1.ato_line_id
894: from bom_cto_order_lines bcol1
895: , oe_order_lines_all oel
896: , mtl_system_items msi
897: -- for configs whose models have attr=2,3
898: where bcol1.config_item_id is not null
899: and bcol1.inventory_item_id = msi.inventory_item_id

Line 993: , oe_order_lines_all oel

989: , nvl(msi.config_orgs, '1')
990: from bom_cto_order_lines bcol1
991: , bom_cto_order_lines bcol2
992: , bom_ato_configurations bac
993: , oe_order_lines_all oel
994: , mtl_system_items msi
995: -- base model has item attr = 3
996: where bac.base_model_id = msi.inventory_item_id
997: and bac.organization_id = msi.organization_id

Line 1241: , oe_order_lines_all oel

1237: , bcol.QTY_PER_PARENT_MODEL
1238: , 'UPG' --STATUS
1239: , nvl(msi.CONFIG_ORGS, '1')
1240: from bom_cto_order_lines bcol
1241: , oe_order_lines_all oel
1242: , mtl_system_items msi
1243: -- select all configs on open order lines
1244: where bcol.ato_line_id = oel.ato_line_id
1245: and nvl(oel.open_flag, 'N') = 'Y'

Line 1336: , oe_order_lines_all oel

1332: , nvl(msi.CONFIG_ORGS, '1')
1333: from bom_cto_order_lines bcol1
1334: , bom_cto_order_lines bcol2
1335: , bom_ato_configurations bac
1336: , oe_order_lines_all oel
1337: , mtl_system_items msi
1338: -- base model has item attr = 3
1339: where bac.base_model_id = msi.inventory_item_id
1340: and bac.organization_id = msi.organization_id

Line 1722: , oe_order_lines_all oel

1718: --, bcol2.SEQUENCE
1719: , nvl(msi.config_orgs, '1')
1720: from bom_cto_order_lines bcol1
1721: , bom_cto_order_lines bcol2
1722: , oe_order_lines_all oel
1723: , mtl_system_items msi
1724: , mtl_item_categories mcat
1725: -- select entire configuration
1726: where bcol2.ato_line_id = bcol1.ato_line_id

Line 1829: , oe_order_lines_all oel

1825: , nvl(msi.config_orgs, '1')
1826: from bom_cto_order_lines bcol1
1827: , bom_cto_order_lines bcol2
1828: , bom_ato_configurations bac
1829: , oe_order_lines_all oel
1830: , mtl_system_items msi
1831: , mtl_item_categories mcat
1832: -- base model has item attr = 3
1833: where bac.base_model_id = msi.inventory_item_id

Line 2090: , oe_order_lines_all oel

2086: , 'UPG' --STATUS
2087: --, bcol.SEQUENCE
2088: , nvl(msi2.CONFIG_ORGS, '1')
2089: from bom_cto_order_lines bcol
2090: , oe_order_lines_all oel
2091: , mtl_system_items msi2
2092: -- select all configs on open order lines
2093: where bcol.ato_line_id = oel.ato_line_id
2094: and bcol.inventory_item_id = msi2.inventory_item_id

Line 2200: , oe_order_lines_all oel

2196: , nvl(msi.CONFIG_ORGS, '1')
2197: from bom_cto_order_lines bcol1
2198: , bom_cto_order_lines bcol2
2199: , bom_ato_configurations bac
2200: , oe_order_lines_all oel
2201: , mtl_system_items msi
2202: , mtl_item_categories mcat
2203: -- base model has item attr = 3
2204: where bac.base_model_id = msi.inventory_item_id

Line 2554: , oe_order_lines_all oel

2550: --, bcol2.SEQUENCE
2551: , nvl(msi.config_orgs, '1')
2552: from bom_cto_order_lines bcol1
2553: , bom_cto_order_lines bcol2
2554: , oe_order_lines_all oel
2555: , mtl_system_items msi
2556: , oe_order_lines_all oel2 --bugfix 3371155
2557: -- select entire configuration
2558: where bcol2.ato_line_id = bcol1.ato_line_id

Line 2556: , oe_order_lines_all oel2 --bugfix 3371155

2552: from bom_cto_order_lines bcol1
2553: , bom_cto_order_lines bcol2
2554: , oe_order_lines_all oel
2555: , mtl_system_items msi
2556: , oe_order_lines_all oel2 --bugfix 3371155
2557: -- select entire configuration
2558: where bcol2.ato_line_id = bcol1.ato_line_id
2559: -- to get item attribute
2560: and msi.inventory_item_id = bcol2.inventory_item_id

Line 2663: , oe_order_lines_all oel

2659: , nvl(msi.config_orgs, '1')
2660: from bom_cto_order_lines bcol1
2661: , bom_cto_order_lines bcol2
2662: , bom_ato_configurations bac
2663: , oe_order_lines_all oel
2664: , mtl_system_items msi
2665: where bac.config_item_id = p_config_id
2666: -- and exists in bcol
2667: and bac.config_item_id = bcol1.config_item_id

Line 3671: oe_order_lines_all oel,

3667: oeh.order_number,
3668: decode(bcolu.status, 'MRP_SRC', 'was successfully processed', 'errored out') status
3669: from bom_cto_order_lines_upg bcolu,
3670: mtl_system_items_kfv msi,
3671: oe_order_lines_all oel,
3672: oe_order_headers_all oeh
3673: where bcolu.config_item_id is not null
3674: and bcolu.config_item_id = msi.inventory_item_id
3675: and bcolu.ship_from_org_id = msi.organization_id