APPS.BOM_DELETE_ITEMS dependencies on BOM_OPERATIONAL_ROUTINGS

Line 377: BOM_OPERATIONAL_ROUTINGS BOR,

373: userid,
374: last_login_id
375: FROM
376: MTL_CATALOG_SEARCH_ITEMS MCSI,
377: BOM_OPERATIONAL_ROUTINGS BOR,
378: MTL_ITEM_FLEXFIELDS MIF
379: WHERE MCSI.ORGANIZATION_ID = org_id
380: AND MCSI.INVENTORY_ITEM_ID = BOR.ASSEMBLY_ITEM_ID
381: AND MCSI.ORGANIZATION_ID = BOR.ORGANIZATION_ID

Line 700: BOM_OPERATIONAL_ROUTINGS BOR,

696: SYSDATE,
697: userid,
698: last_login_id
699: FROM
700: BOM_OPERATIONAL_ROUTINGS BOR,
701: MTL_SYSTEM_ITEMS MSI,
702: MTL_ITEM_FLEXFIELDS MIF
703: WHERE BOR.ORGANIZATION_ID = org_id
704: AND MSI.INVENTORY_ITEM_ID = BOR.ASSEMBLY_ITEM_ID

Line 712: BOM_OPERATIONAL_ROUTINGS BOR,

708: AND BOR.ROUTING_TYPE = eng_flag
709: AND BOR.ROUTING_SEQUENCE_ID IN(
710: SELECT DISTINCT BOS.ROUTING_SEQUENCE_ID
711: FROM
712: BOM_OPERATIONAL_ROUTINGS BOR,
713: BOM_OPERATION_SEQUENCES BOS
714: WHERE BOR.ROUTING_SEQUENCE_ID = BOS.ROUTING_SEQUENCE_ID
715: AND BOS.DISABLE_DATE <= expiration_date
716: AND BOS.ROUTING_SEQUENCE_ID NOT IN(

Line 752: BOM_OPERATIONAL_ROUTINGS BOR,

748: last_login_id
749: FROM
750: BOM_OPERATION_SEQUENCES BOS,
751: BOM_DELETE_ENTITIES BDE,
752: BOM_OPERATIONAL_ROUTINGS BOR,
753: BOM_DEPARTMENTS BD
754: WHERE BOR.ROUTING_SEQUENCE_ID = BOS.ROUTING_SEQUENCE_ID
755: AND BDE.ROUTING_SEQUENCE_ID = BOS.ROUTING_SEQUENCE_ID
756: AND BOR.ROUTING_TYPE = eng_flag

Line 975: BOM_OPERATIONAL_ROUTINGS BOR,

971: userid,
972: SYSDATE,
973: userid
974: FROM
975: BOM_OPERATIONAL_ROUTINGS BOR,
976: MTL_SYSTEM_ITEMS MSI,
977: MTL_ITEM_FLEXFIELDS MIF
978: WHERE ASSEMBLY_ITEM_ID = BR_GetDelEntitiesREC.INVENTORY_ITEM_ID
979: AND BOR.ORGANIZATION_ID = BR_GetDelEntitiesREC.ORGANIZATION_ID