DBA Data[Home] [Help]

APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_MC_PATH_POSITIONS

Line 733: FROM AHL_RT_OPER_MATERIALS ROM, AHL_MC_PATH_POSITIONS PP

729: ITEM_COMP_DETAIL_ID,
730: POSITION_PATH_ID,
731: PP.PATH_POS_COMMON_ID,
732: PP.VER_SPEC_SCORE
733: FROM AHL_RT_OPER_MATERIALS ROM, AHL_MC_PATH_POSITIONS PP
734: WHERE OBJECT_ID in (NVL(c_mc_route_eff_id, -1), NVL(c_item_route_eff_id, -1)) AND
735: ROM.POSITION_PATH_ID = PP.PATH_POSITION_ID (+) AND
736: ASSOCIATION_TYPE_CODE = G_ASSOC_TYPE_DISPOSITION AND
737: ((REPLACE_PERCENT = 100 AND p_request_type = G_REQ_TYPE_FORECAST) OR