DBA Data[Home] [Help]

APPS.AHL_FMP_COMMON_PVT dependencies on CSI_ITEM_INSTANCES

Line 1886: CSI_ITEM_INSTANCES csi,

1882: WHERE
1883: EXISTS (
1884: SELECT 'x'
1885: FROM AHL_UNIT_EFFECTIVITIES_B unit,
1886: CSI_ITEM_INSTANCES csi,
1887: AHL_MR_EFFECTIVITIES eff
1888: where
1889: eff.inventory_item_id = csi.INVENTORY_ITEM_ID
1890: and unit.CSI_ITEM_INSTANCE_ID = csi.instance_id

Line 1936: CSI_ITEM_INSTANCES csi,

1932: SELECT 1
1933: FROM DUAL
1934: WHERE EXISTS ( SELECT 'x'
1935: FROM AHL_UNIT_EFFECTIVITIES_B unit,
1936: CSI_ITEM_INSTANCES csi,
1937: AHL_MR_EFFECTIVITIES eff
1938: where
1939: eff.inventory_item_id = csi.INVENTORY_ITEM_ID
1940: and unit.CSI_ITEM_INSTANCE_ID = csi.instance_id