APPS.CZ_BOM_CONFIG_EXPLOSIONS_PKG dependencies on BOM_CTO_SRC_ORGS

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 2049: from bom_cto_src_orgs

2045:
2046:
2047:
2048: select decode( count(*) , 0 , 'N' , 'Y' ) into x_mlmo_item_created
2049: from bom_cto_src_orgs
2050: where organization_id <> nvl(rcv_org_id, organization_id)
2051: and top_model_line_id = p_top_ato_line_id ;
2052:
2053:

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: