APPS.BOM_RTG_ISETUP_IMP dependencies on BOM_OPERATION_NETWORKS

Line 682: -- BOM_OPERATION_NETWORKS

678: AND oper.effectivity_date = TO_DATE(tmp.StartEffectiveDate,'YYYY-MM-DD HH24:MI:SS')
679: AND NVL(sub_oper.schedule_seq_num,-99999) = NVL(tmp.ScheduleSequenceNumber,-99999)
680: AND sub_oper.substitute_group_num = tmp.SubstituteGroupNumber);
681:
682: -- BOM_OPERATION_NETWORKS
683: -- From_Op_Seq_Id
684: -- To_Op_Seq_Id
685:
686: CURSOR rtg_op_networks_CUR(P_assembly_item_name VARCHAR2,

Line 732: FROM bom_operation_networks op_network,

728: WHERE tmp.AssemblyItemName = P_assembly_item_name
729: AND tmp.OrganizationCode = P_organization_code
730: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
731: AND NOT EXISTS (SELECT 1
732: FROM bom_operation_networks op_network,
733: bom_operational_routings rtg,
734: bom_operation_sequences oper1,
735: bom_operation_sequences oper2,
736: mtl_parameters org,

Line 798: FROM bom_operation_networks op_network,

794: WHERE tmp.AssemblyItemName = P_assembly_item_name
795: AND tmp.OrganizationCode = P_organization_code
796: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
797: AND EXISTS (SELECT 1
798: FROM bom_operation_networks op_network,
799: bom_operational_routings rtg,
800: bom_operation_sequences oper1,
801: bom_operation_sequences oper2,
802: mtl_parameters org,