DBA Data[Home] [Help]

APPS.AHL_LTP_SPACE_SCHEDULE_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 5275: MTL_SYSTEM_ITEMS_B_KFV mtl,

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(+)
5279: and VST.INVENTORY_ITEM_ID = mtl.INVENTORY_ITEM_ID(+)

Line 5312: MTL_SYSTEM_ITEMS_B_KFV mtl,

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(+)
5316: AND VST.ITEM_ORGANIZATION_ID = mtl.ORGANIZATION_ID(+)