APPS.CZ_BOM_CONFIG_EXPLOSIONS_PKG dependencies on BOM_CTO_SRC_ORGS_B

Line 1852: from bom_operational_routings bor, bom_cto_src_orgs bcso

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

Line 2085: delete from bom_cto_src_orgs_b

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