DBA Data[Home] [Help]

APPS.AHL_LTP_SPACE_SCHEDULE_PVT dependencies on CSI_ITEM_INSTANCES

Line 5274: CSI_ITEM_INSTANCES CSI ,

5270: AND B.VISIT_ID = VST.VISIT_ID
5271: GROUP BY VISIT_ID
5272: ) due_by
5273: FROM AHL_VISITS_VL VST,
5274: CSI_ITEM_INSTANCES CSI ,
5275: MTL_SYSTEM_ITEMS_B_KFV mtl,
5276: FND_LOOKUP_VALUES_VL FLVT,
5277: ahl_space_assignments SPS
5278: where VST.ITEM_INSTANCE_ID = CSI.INSTANCE_ID(+)

Line 5311: CSI_ITEM_INSTANCES CSI ,

5307: AND B.VISIT_ID = VST.VISIT_ID
5308: GROUP BY VISIT_ID
5309: ) due_by
5310: FROM AHL_VISITS_VL VST,
5311: CSI_ITEM_INSTANCES CSI ,
5312: MTL_SYSTEM_ITEMS_B_KFV mtl,
5313: FND_LOOKUP_VALUES_VL FLVT
5314: where VST.ITEM_INSTANCE_ID = CSI.INSTANCE_ID(+)
5315: and VST.INVENTORY_ITEM_ID = mtl.INVENTORY_ITEM_ID(+)