DBA Data[Home] [Help]

APPS.BOM_RTG_ISETUP_IMP dependencies on BOM_SUB_OPERATION_RESOURCES

Line 592: FROM BOM_SUB_OPERATION_RESOURCES sub_oper,

588: WHERE tmp.AssemblyItemName = P_assembly_item_name
589: AND tmp.OrganizationCode = P_organization_code
590: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
591: AND EXISTS (SELECT 1
592: FROM BOM_SUB_OPERATION_RESOURCES sub_oper,
593: bom_operational_routings rtg,
594: BOM_OPERATION_SEQUENCES oper,
595: mtl_parameters org,
596: mtl_system_items_kfv item

Line 663: FROM BOM_SUB_OPERATION_RESOURCES sub_oper,

659: WHERE tmp.AssemblyItemName = P_assembly_item_name
660: AND tmp.OrganizationCode = P_organization_code
661: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
662: AND NOT EXISTS (SELECT 1
663: FROM BOM_SUB_OPERATION_RESOURCES sub_oper,
664: bom_operational_routings rtg,
665: BOM_OPERATION_SEQUENCES oper,
666: mtl_parameters org,
667: mtl_system_items_kfv item