DBA Data[Home] [Help]

APPS.AHL_FMP_COMMON_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 1826: FROM AHL_UNIT_EFFECTIVITIES_B unit,

1822: FROM DUAL
1823: WHERE
1824: EXISTS (
1825: SELECT 'x'
1826: FROM AHL_UNIT_EFFECTIVITIES_B unit,
1827: CSI_ITEM_INSTANCES csi,
1828: AHL_MR_EFFECTIVITIES eff
1829: where
1830: eff.inventory_item_id = csi.INVENTORY_ITEM_ID

Line 1876: FROM AHL_UNIT_EFFECTIVITIES_B unit,

1872: IS
1873: SELECT 1
1874: FROM DUAL
1875: WHERE EXISTS ( SELECT 'x'
1876: FROM AHL_UNIT_EFFECTIVITIES_B unit,
1877: CSI_ITEM_INSTANCES csi,
1878: AHL_MR_EFFECTIVITIES eff
1879: where
1880: eff.inventory_item_id = csi.INVENTORY_ITEM_ID