DBA Data[Home] [Help]

APPS.CZ_BOM_CONFIG_EXPLOSIONS_PKG dependencies on BOM_OPERATIONAL_ROUTINGS

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