APPS.AHL_RM_ROUTE_UTIL dependencies on AHL_MTL_ITEMS_NON_OU_V

Line 558: from ahl_mtl_items_non_ou_v mtl

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

Line 609: from ahl_mtl_items_non_ou_v mtl

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

Line 3996: , AHL_MTL_ITEMS_NON_OU_V MTL

3992: SELECT DISTINCT MTL.CONCATENATED_SEGMENTS
3993: , MTL.ORGANIZATION_CODE
3994: FROM AHL_ITEM_COMP_DETAILS ICD
3995: , AHL_ITEM_COMPOSITIONS CD
3996: , AHL_MTL_ITEMS_NON_OU_V MTL
3997: WHERE ICD.item_comp_detail_id = c_item_comp_detail_id
3998: AND CD.APPROVAL_STATUS_CODE ='COMPLETE'
3999: AND CD.item_composition_id = ICD.item_composition_id
4000: AND CD.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID

Line 4052: ahl_mtl_items_non_ou_v mtl,

4048: /*select distinct
4049: mtl.concatenated_segments ,
4050: mtl.organization_code
4051: from
4052: ahl_mtl_items_non_ou_v mtl,
4053: ahl_position_alternates_v pal,
4054: AHL_ITEM_COMP_V CD ,
4055: AHL_ITEM_COMP_DETAILS ICD
4056: where

Line 4079: -- ahl_mtl_items_non_ou_v mtl,

4075: ahl_mc_headers_b mch,
4076: ahl_mc_path_position_nodes mcp,
4077: ahl_item_associations_v igass ,
4078: AHL_ROUTE_EFFECTIVITIES re ,
4079: -- ahl_mtl_items_non_ou_v mtl,
4080: AHL_ITEM_COMP_V CD ,
4081: AHL_ITEM_COMP_DETAILS ICD
4082: WHERE
4083: mch.mc_header_id = mcr.mc_header_id