DBA Data[Home] [Help]

APPS.AHL_FMP_EFFECTIVITY_DTL_PVT dependencies on AHL_POSITION_ALTERNATES_V

Line 905: ahl_position_alternates_v PA,

901: CSI.inventory_item_id = EFF.inventory_item_id
902: UNION
903: select distinct MIN(CSI.serial_number) , MAX(CSI.serial_number)
904: from csi_item_instances CSI,
905: ahl_position_alternates_v PA,
906: AHL_MR_EFFECTIVITIES EFF
907: where
908: EFF.MR_EFFECTIVITY_ID = c_mr_effectivity_id and
909: EFF.RELATIONSHIP_ID = PA.relationship_id and