DBA Data[Home] [Help]

APPS.GML_MOBILE_RECEIPT dependencies on MTL_SECONDARY_LOCATORS

Line 3479: FROM mtl_item_locations_kfv a,mtl_secondary_locators b, ic_loct_mst l

3475: OPEN x_Locators FOR
3476: select a.inventory_location_id,
3477: INV_PROJECT.GET_LOCSEGS(a.concatenated_segments),
3478: nvl( a.description, -1)
3479: FROM mtl_item_locations_kfv a,mtl_secondary_locators b, ic_loct_mst l
3480: WHERE b.organization_id = p_Organization_Id
3481: AND b.inventory_item_id = p_Inventory_Item_Id
3482: AND a.inventory_location_id = l.inventory_location_id
3483: AND nvl(a.disable_date, trunc(sysdate+1)) > trunc(sysdate)

Line 3542: FROM mtl_item_locations_kfv a,mtl_secondary_locators b, ic_loct_mst l

3538: OPEN x_Locators FOR
3539: select a.inventory_location_id,
3540: INV_PROJECT.GET_LOCSEGS(a.concatenated_segments),
3541: nvl( a.description, -1)
3542: FROM mtl_item_locations_kfv a,mtl_secondary_locators b, ic_loct_mst l
3543: WHERE b.organization_id = p_Organization_Id
3544: AND b.inventory_item_id = p_Inventory_Item_Id
3545: AND a.inventory_location_id = l.inventory_location_id
3546: AND nvl(a.disable_date, trunc(sysdate+1)) > trunc(sysdate)