DBA Data[Home] [Help]

APPS.GML_MOBILE_RECEIPT dependencies on INV_PROJECT

Line 3477: INV_PROJECT.GET_LOCSEGS(a.concatenated_segments),

3473: IF p_Restrict_Locators_Code = 1 THEN --Locators restricted to predefined list
3474:
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

Line 3509: INV_PROJECT.GET_LOCSEGS(concatenated_segments),

3505: ELSE --Locators not restricted
3506:
3507: OPEN x_Locators FOR
3508: select a.inventory_location_id,
3509: INV_PROJECT.GET_LOCSEGS(concatenated_segments),
3510: description
3511: FROM mtl_item_locations_kfv a, ic_loct_mst l
3512: WHERE organization_id = p_Organization_Id
3513: AND subinventory_code = p_Subinventory_Code

Line 3540: INV_PROJECT.GET_LOCSEGS(a.concatenated_segments),

3536: IF p_Restrict_Locators_Code = 1 THEN --Locators restricted to predefined list
3537:
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

Line 3570: INV_PROJECT.GET_LOCSEGS(concatenated_segments),

3566:
3567: ELSE --Locators not restricted
3568: OPEN x_Locators FOR
3569: select a.inventory_location_id,
3570: INV_PROJECT.GET_LOCSEGS(concatenated_segments),
3571: description
3572: FROM mtl_item_locations_kfv a, ic_loct_mst l
3573: WHERE organization_id = p_Organization_Id
3574: AND subinventory_code = p_Subinventory_Code