DBA Data[Home] [Help]

APPS.CTO_DEACTIVATE_CONFIG_PK dependencies on OE_ORDER_LINES_ALL

Line 2560: FROM oe_order_lines_all oel1, oe_order_lines_all oel2

2556:
2557: --Begin Performance fix 7014363
2558: /*CURSOR c_bcso IS
2559: SELECT oel1.open_flag
2560: FROM oe_order_lines_all oel1, oe_order_lines_all oel2
2561: WHERE oel1.line_id IN
2562: ( SELECT bcso.line_id
2563: FROM bom_cto_src_orgs bcso
2564: WHERE bcso.config_item_id = p_inventory_item_id

Line 2572: FROM oe_order_lines_all oel1,

2568: AND oel2.item_type_code = 'CONFIG';*/
2569:
2570: CURSOR c_bcso IS
2571: SELECT oel1.open_flag
2572: FROM oe_order_lines_all oel1,
2573: oe_order_lines_all oel2
2574: WHERE oel1.line_id IN
2575: ( SELECT line_id line_id
2576: FROM bom_cto_src_orgs_b bcso

Line 2573: oe_order_lines_all oel2

2569:
2570: CURSOR c_bcso IS
2571: SELECT oel1.open_flag
2572: FROM oe_order_lines_all oel1,
2573: oe_order_lines_all oel2
2574: WHERE oel1.line_id IN
2575: ( SELECT line_id line_id
2576: FROM bom_cto_src_orgs_b bcso
2577: WHERE group_reference_id IS NULL

Line 2597: FROM oe_order_lines_all

2593:
2594: --this checks for demand of config item when order as an ATO item
2595: CURSOR c_ato_item IS
2596: SELECT open_flag
2597: FROM oe_order_lines_all
2598: WHERE inventory_item_id = p_inventory_item_id
2599: AND ship_from_org_id = p_org_id
2600: AND open_flag <> 'N'
2601: UNION