DBA Data[Home] [Help]

APPS.CTO_DEACTIVATE_CONFIG_PK dependencies on BOM_CTO_SRC_ORGS_B

Line 2563: FROM bom_cto_src_orgs bcso

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
2565: AND bcso.organization_id = p_org_id)
2566: AND oel1.OPEN_FLAG <> 'N'
2567: AND oel1.ato_line_id = oel2.ato_line_id

Line 2576: FROM bom_cto_src_orgs_b bcso

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
2578: AND bcso.config_item_id = p_inventory_item_id
2579: AND bcso.organization_id = p_org_id
2580: UNION ALL

Line 2582: FROM bom_cto_src_orgs_b bcso,

2578: AND bcso.config_item_id = p_inventory_item_id
2579: AND bcso.organization_id = p_org_id
2580: UNION ALL
2581: SELECT bcso.line_id line_id
2582: FROM bom_cto_src_orgs_b bcso,
2583: bom_cto_model_orgs bcmo
2584: WHERE bcso.group_reference_id IS NOT NULL
2585: AND bcso.group_reference_id = bcmo.group_reference_id
2586: AND bcso.config_item_id = p_inventory_item_id