DBA Data[Home] [Help]

APPS.AHL_LTP_MTL_REQ_PVT dependencies on AHL_MC_PATH_POSITIONS

Line 676: FROM AHL_RT_OPER_MATERIALS ROM, AHL_MC_PATH_POSITIONS PP

672: ITEM_COMP_DETAIL_ID,
673: POSITION_PATH_ID,
674: PP.PATH_POS_COMMON_ID,
675: PP.VER_SPEC_SCORE
676: FROM AHL_RT_OPER_MATERIALS ROM, AHL_MC_PATH_POSITIONS PP
677: WHERE OBJECT_ID in (NVL(c_mc_route_eff_id, -1), NVL(c_item_route_eff_id, -1)) AND
678: ROM.POSITION_PATH_ID = PP.PATH_POSITION_ID (+) AND
679: ASSOCIATION_TYPE_CODE = G_ASSOC_TYPE_DISPOSITION AND
680: ((REPLACE_PERCENT = 100 AND p_request_type = G_REQ_TYPE_FORECAST) OR