DBA Data[Home] [Help]

APPS.AHL_FMP_EFFECTIVITY_DTL_PVT dependencies on AHL_POSITION_ALTERNATES_V

Line 1749: ahl_position_alternates_v PA,

1745: CSI.inventory_item_id = EFF.inventory_item_id
1746: UNION
1747: select distinct MIN(CSI.serial_number) , MAX(CSI.serial_number)
1748: from csi_item_instances CSI,
1749: ahl_position_alternates_v PA,
1750: AHL_MR_EFFECTIVITIES EFF
1751: where
1752: EFF.MR_EFFECTIVITY_ID = c_mr_effectivity_id and
1753: EFF.RELATIONSHIP_ID = PA.relationship_id and