APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_MTL_ITEMS_NON_OU_V

Line 556: from ahl_mtl_items_non_ou_v mtl

552: NVL(mtl.inventory_item_flag,'X'),
553: NVL(mtl.mtl_transactions_enabled_flag,'X'),
554: NVL(mtl.stock_enabled_flag,'X'),
555: NVL(mtl.wip_supply_type,0)
556: from ahl_mtl_items_non_ou_v mtl
557: where
558: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mtl.eam_enabled_flag )='Y'
559: AND mtl.enabled_flag = 'Y'
560: AND SYSDATE BETWEEN NVL( mtl.start_date_active, SYSDATE )

Line 607: from ahl_mtl_items_non_ou_v mtl

603: NVL(mtl.inventory_item_flag,'X'),
604: NVL(mtl.mtl_transactions_enabled_flag,'X'),
605: NVL(mtl.stock_enabled_flag,'X'),
606: NVL(mtl.wip_supply_type,0)
607: from ahl_mtl_items_non_ou_v mtl
608: where
609: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mtl.eam_enabled_flag )='Y'
610: AND mtl.enabled_flag = 'Y'
611: AND SYSDATE BETWEEN NVL( mtl.start_date_active, SYSDATE )

Line 3697: , AHL_MTL_ITEMS_NON_OU_V MTL

3693: SELECT DISTINCT MTL.CONCATENATED_SEGMENTS
3694: , MTL.ORGANIZATION_CODE
3695: FROM AHL_ITEM_COMP_DETAILS ICD
3696: , AHL_ITEM_COMPOSITIONS CD
3697: , AHL_MTL_ITEMS_NON_OU_V MTL
3698: WHERE ICD.item_comp_detail_id = c_item_comp_detail_id
3699: AND CD.APPROVAL_STATUS_CODE ='COMPLETE'
3700: AND CD.item_composition_id = ICD.item_composition_id
3701: AND CD.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID

Line 3753: ahl_mtl_items_non_ou_v mtl,

3749: /*select distinct
3750: mtl.concatenated_segments ,
3751: mtl.organization_code
3752: from
3753: ahl_mtl_items_non_ou_v mtl,
3754: ahl_position_alternates_v pal,
3755: AHL_ITEM_COMP_V CD ,
3756: AHL_ITEM_COMP_DETAILS ICD
3757: where

Line 3780: -- ahl_mtl_items_non_ou_v mtl,

3776: ahl_mc_headers_b mch,
3777: ahl_mc_path_position_nodes mcp,
3778: ahl_item_associations_v igass ,
3779: AHL_ROUTE_EFFECTIVITIES re ,
3780: -- ahl_mtl_items_non_ou_v mtl,
3781: AHL_ITEM_COMP_V CD ,
3782: AHL_ITEM_COMP_DETAILS ICD
3783: WHERE
3784: mch.mc_header_id = mcr.mc_header_id