DBA Data[Home] [Help]

APPS.AHL_PRD_MRSHL_PVT dependencies on AHL_VISITS_B

Line 263: FROM AHL_VISITS_B AVTS,mtl_item_locations_kfv MTLI,

259: || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
260: || INV_ProjectLocator_PUB.get_project_number(MSI.segment19)
261: || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
262: || INV_ProjectLocator_PUB.get_task_number(MSI.segment20)) locator_segments
263: FROM AHL_VISITS_B AVTS,mtl_item_locations_kfv MTLI,
264: mtl_item_locations MSI
265: WHERE
266: AVTS.STATUS_CODE IN ('RELEASED', 'CLOSED', 'PARTIALLY RELEASED')
267: AND MTLI.inventory_location_id(+) = AVTS.inv_locator_id

Line 685: FROM AHL_VISITS_B AVTS,mtl_item_locations_kfv MTLI,

681: || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
682: || INV_ProjectLocator_PUB.get_project_number(MSI.segment19)
683: || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
684: || INV_ProjectLocator_PUB.get_task_number(MSI.segment20)) locator_segments
685: FROM AHL_VISITS_B AVTS,mtl_item_locations_kfv MTLI,
686: mtl_item_locations MSI
687: WHERE
688: AVTS.STATUS_CODE IN ('RELEASED', 'CLOSED', 'PARTIALLY RELEASED')
689: AND MTLI.inventory_location_id(+) = AVTS.inv_locator_id

Line 1279: FROM AHL_VISITS_B AVTS,mtl_item_locations_kfv MTLI,

1275: || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
1276: || INV_ProjectLocator_PUB.get_project_number(MSI.segment19)
1277: || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
1278: || INV_ProjectLocator_PUB.get_task_number(MSI.segment20)) locator_segments
1279: FROM AHL_VISITS_B AVTS,mtl_item_locations_kfv MTLI,
1280: mtl_item_locations MSI
1281: WHERE
1282: AVTS.STATUS_CODE IN ('RELEASED', 'CLOSED', 'PARTIALLY RELEASED')
1283: AND MTLI.inventory_location_id(+) = AVTS.inv_locator_id