APPS.CZ_BOM_CONFIG_EXPLOSIONS_PKG dependencies on BOM_CTO_SRC_ORGS_B

Line 1849: from bom_operational_routings bor, bom_cto_src_orgs bcso

1845: select 'Y' into x_routing_exists
1846: from dual
1847: where EXISTS (
1848: select routing_sequence_id
1849: from bom_operational_routings bor, bom_cto_src_orgs bcso
1850: where bor.assembly_item_id = bcso.config_item_id
1851: and bor.organization_id = bcso.organization_id
1852: and bor.alternate_routing_designator is null
1853: and bcso.line_id = p_top_ato_line_id

Line 2082: delete from bom_cto_src_orgs_b

2078: where ato_line_id = p_top_ato_line_id ;
2079:
2080: CTO_WIP_WORKFLOW_API_PK.CTO_DEBUG( 'CREATE_PRECONFIG_ITEM_ML' , ' deleted bcol ' || to_char(sql%rowcount)) ;
2081:
2082: delete from bom_cto_src_orgs_b
2083: where top_model_line_id = p_top_ato_line_id ;
2084:
2085: CTO_WIP_WORKFLOW_API_PK.CTO_DEBUG( 'CREATE_PRECONFIG_ITEM_ML' , ' deleted bcso_b ' || to_char(sql%rowcount)) ;
2086: