593: WHERE tmp.AssemblyItemName = P_assembly_item_name
594: AND tmp.OrganizationCode = P_organization_code
595: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
596: AND EXISTS (SELECT 1
597: FROM BOM_SUB_OPERATION_RESOURCES sub_oper,
598: bom_operational_routings rtg,
599: BOM_OPERATION_SEQUENCES oper,
600: mtl_parameters org,
601: mtl_system_items_kfv item
665: WHERE tmp.AssemblyItemName = P_assembly_item_name
666: AND tmp.OrganizationCode = P_organization_code
667: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
668: AND NOT EXISTS (SELECT 1
669: FROM BOM_SUB_OPERATION_RESOURCES sub_oper,
670: bom_operational_routings rtg,
671: BOM_OPERATION_SEQUENCES oper,
672: mtl_parameters org,
673: mtl_system_items_kfv item