APPS.BOM_RTG_ISETUP_IMP dependencies on BOM_OPERATION_NETWORKS

Line 688: -- BOM_OPERATION_NETWORKS

684: AND oper.effectivity_date = TO_DATE(tmp.StartEffectiveDate,'YYYY-MM-DD HH24:MI:SS')
685: AND NVL(sub_oper.schedule_seq_num,-99999) = NVL(tmp.ScheduleSequenceNumber,-99999)
686: AND sub_oper.substitute_group_num = tmp.SubstituteGroupNumber);
687:
688: -- BOM_OPERATION_NETWORKS
689: -- From_Op_Seq_Id
690: -- To_Op_Seq_Id
691:
692: CURSOR rtg_op_networks_CUR(P_assembly_item_name VARCHAR2,

Line 738: FROM bom_operation_networks op_network,

734: WHERE tmp.AssemblyItemName = P_assembly_item_name
735: AND tmp.OrganizationCode = P_organization_code
736: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
737: AND NOT EXISTS (SELECT 1
738: FROM bom_operation_networks op_network,
739: bom_operational_routings rtg,
740: bom_operation_sequences oper1,
741: bom_operation_sequences oper2,
742: mtl_parameters org,

Line 804: FROM bom_operation_networks op_network,

800: WHERE tmp.AssemblyItemName = P_assembly_item_name
801: AND tmp.OrganizationCode = P_organization_code
802: AND NVL(tmp.AlternateRoutingCode,'$$##$$') = NVL(P_alternate_routing_code,'$$##$$')
803: AND EXISTS (SELECT 1
804: FROM bom_operation_networks op_network,
805: bom_operational_routings rtg,
806: bom_operation_sequences oper1,
807: bom_operation_sequences oper2,
808: mtl_parameters org,