eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on INV_PROJECT

Line 1533: * Use the function INV_PROJECT.get_locsegs() to retrieve the

1529: END get_mo_toloc_lov;
1530:
1531: /* PJM-WMS Integration:Return only the the physical locators.
1532: * Use the table mtl_item_locations instead of mtl_item_locations_kfv.
1533: * Use the function INV_PROJECT.get_locsegs() to retrieve the
1534: * concatenated segments.Filter the locators based on the Project
1535: * and Task passed to the procedure.
1536: */
1537: PROCEDURE get_loc_with_status(x_locators OUT NOCOPY t_genref,

Line 2621: AND concatenated_segments LIKE (p_concatenated_segments )-- inv_project.get_locsegs(inventory_location_id,organization_id) LIKE (p_concatenated_segments || '%')

2617: description
2618: FROM wms_item_locations_kfv
2619: WHERE organization_id = p_organization_id
2620: AND subinventory_code = p_subinventory_code
2621: AND concatenated_segments LIKE (p_concatenated_segments )-- inv_project.get_locsegs(inventory_location_id,organization_id) LIKE (p_concatenated_segments || '%')
2622: AND project_id = p_project_id
2623: AND task_id = p_task_id
2624: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE) -- bug # 4866575
2625: AND (INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

Line 2649: AND concatenated_segments LIKE (p_concatenated_segments )--inv_project.get_locsegs(inventory_location_id,organization_id) LIKE (p_concatenated_segments || '%')

2645: description
2646: FROM wms_item_locations_kfv
2647: WHERE organization_id = p_organization_id
2648: AND subinventory_code = p_subinventory_code
2649: AND concatenated_segments LIKE (p_concatenated_segments )--inv_project.get_locsegs(inventory_location_id,organization_id) LIKE (p_concatenated_segments || '%')
2650: AND project_id = p_project_id
2651: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE) -- bug # 4866575
2652: AND (INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
2653: NULL,

Line 2677: AND concatenated_segments LIKE (p_concatenated_segments )-- inv_project.get_locsegs(inventory_location_id,organization_id) LIKE (p_concatenated_segments || '%')

2673: description
2674: FROM wms_item_locations_kfv
2675: WHERE organization_id = p_organization_id
2676: AND subinventory_code = p_subinventory_code
2677: AND concatenated_segments LIKE (p_concatenated_segments )-- inv_project.get_locsegs(inventory_location_id,organization_id) LIKE (p_concatenated_segments || '%')
2678: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE) -- bug # 4866575
2679: AND (INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
2680: NULL,
2681: 4,

Line 2838: --inv_project.get_locsegs(inventory_location_id,organization_id) LIKE (p_concatenated_segments || '%')

2834: FROM wms_item_locations_kfv
2835: WHERE organization_id = p_organization_id
2836: AND subinventory_code = p_subinventory_code
2837: AND alias = p_alias
2838: --inv_project.get_locsegs(inventory_location_id,organization_id) LIKE (p_concatenated_segments || '%')
2839: AND project_id = p_project_id
2840: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE) -- bug # 4866575
2841: AND (INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
2842: NULL,

Line 2867: -- inv_project.get_locsegs(inventory_location_id,organization_id) LIKE (p_concatenated_segments || '%')

2863: FROM wms_item_locations_kfv
2864: WHERE organization_id = p_organization_id
2865: AND subinventory_code = p_subinventory_code
2866: AND alias = p_alias
2867: -- inv_project.get_locsegs(inventory_location_id,organization_id) LIKE (p_concatenated_segments || '%')
2868: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE) -- bug # 4866575
2869: AND (INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
2870: NULL,
2871: 4,

Line 2906: , inv_project.get_locsegs(a.locator_id, p_organization_id)

2902: , a.subinventory_code
2903: , NVL(a.locator_id, 0)
2904: , NVL(b.asset_inventory, '0')
2905: , 0
2906: , inv_project.get_locsegs(a.locator_id, p_organization_id)
2907: , inv_project.get_project_id
2908: , inv_project.get_project_number
2909: , inv_project.get_task_id
2910: , inv_project.get_task_number

Line 2907: , inv_project.get_project_id

2903: , NVL(a.locator_id, 0)
2904: , NVL(b.asset_inventory, '0')
2905: , 0
2906: , inv_project.get_locsegs(a.locator_id, p_organization_id)
2907: , inv_project.get_project_id
2908: , inv_project.get_project_number
2909: , inv_project.get_task_id
2910: , inv_project.get_task_number
2911: FROM wms_license_plate_numbers a, mtl_secondary_inventories b

Line 2908: , inv_project.get_project_number

2904: , NVL(b.asset_inventory, '0')
2905: , 0
2906: , inv_project.get_locsegs(a.locator_id, p_organization_id)
2907: , inv_project.get_project_id
2908: , inv_project.get_project_number
2909: , inv_project.get_task_id
2910: , inv_project.get_task_number
2911: FROM wms_license_plate_numbers a, mtl_secondary_inventories b
2912: WHERE a.organization_id = p_organization_id

Line 2909: , inv_project.get_task_id

2905: , 0
2906: , inv_project.get_locsegs(a.locator_id, p_organization_id)
2907: , inv_project.get_project_id
2908: , inv_project.get_project_number
2909: , inv_project.get_task_id
2910: , inv_project.get_task_number
2911: FROM wms_license_plate_numbers a, mtl_secondary_inventories b
2912: WHERE a.organization_id = p_organization_id
2913: AND (a.lpn_context = 1 OR a.lpn_context = 11)

Line 2910: , inv_project.get_task_number

2906: , inv_project.get_locsegs(a.locator_id, p_organization_id)
2907: , inv_project.get_project_id
2908: , inv_project.get_project_number
2909: , inv_project.get_task_id
2910: , inv_project.get_task_number
2911: FROM wms_license_plate_numbers a, mtl_secondary_inventories b
2912: WHERE a.organization_id = p_organization_id
2913: AND (a.lpn_context = 1 OR a.lpn_context = 11)
2914: AND b.organization_id(+) = a.organization_id

Line 2959: , inv_project.get_locsegs(a.locator_id, p_organization_id)

2955: , a.subinventory_code
2956: , NVL(a.locator_id, 0)
2957: , NVL(b.asset_inventory, '0')
2958: , 0
2959: , inv_project.get_locsegs(a.locator_id, p_organization_id)
2960: , inv_project.get_project_id
2961: , inv_project.get_project_number
2962: , inv_project.get_task_id
2963: , inv_project.get_task_number

Line 2960: , inv_project.get_project_id

2956: , NVL(a.locator_id, 0)
2957: , NVL(b.asset_inventory, '0')
2958: , 0
2959: , inv_project.get_locsegs(a.locator_id, p_organization_id)
2960: , inv_project.get_project_id
2961: , inv_project.get_project_number
2962: , inv_project.get_task_id
2963: , inv_project.get_task_number
2964: FROM wms_license_plate_numbers a, mtl_secondary_inventories b

Line 2961: , inv_project.get_project_number

2957: , NVL(b.asset_inventory, '0')
2958: , 0
2959: , inv_project.get_locsegs(a.locator_id, p_organization_id)
2960: , inv_project.get_project_id
2961: , inv_project.get_project_number
2962: , inv_project.get_task_id
2963: , inv_project.get_task_number
2964: FROM wms_license_plate_numbers a, mtl_secondary_inventories b
2965: WHERE a.organization_id = p_organization_id

Line 2962: , inv_project.get_task_id

2958: , 0
2959: , inv_project.get_locsegs(a.locator_id, p_organization_id)
2960: , inv_project.get_project_id
2961: , inv_project.get_project_number
2962: , inv_project.get_task_id
2963: , inv_project.get_task_number
2964: FROM wms_license_plate_numbers a, mtl_secondary_inventories b
2965: WHERE a.organization_id = p_organization_id
2966: AND (a.lpn_context = 1 OR a.lpn_context = 11)

Line 2963: , inv_project.get_task_number

2959: , inv_project.get_locsegs(a.locator_id, p_organization_id)
2960: , inv_project.get_project_id
2961: , inv_project.get_project_number
2962: , inv_project.get_task_id
2963: , inv_project.get_task_number
2964: FROM wms_license_plate_numbers a, mtl_secondary_inventories b
2965: WHERE a.organization_id = p_organization_id
2966: AND (a.lpn_context = 1 OR a.lpn_context = 11)
2967: AND b.organization_id(+) = a.organization_id

Line 3641: * Use the function INV_PROJECT.get_locsegs() to retrieve the

3637: -- cycle count
3638: --
3639: /* PJM-WMS Integration:Return only the the physical locators.
3640: * Use the table mtl_item_locations instead of mtl_item_locations_kfv.
3641: * Use the function INV_PROJECT.get_locsegs() to retrieve the
3642: * concatenated segments.
3643: */
3644: PROCEDURE get_cgupdate_locs(x_locators OUT NOCOPY t_genref, p_organization_id IN NUMBER, p_subinventory_code IN VARCHAR2, p_concatenated_segments IN VARCHAR2, p_inventory_item_id IN NUMBER, p_revision IN VARCHAR2) IS
3645: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 3939: l_return_value := inv_projectlocator_pub.get_physical_location(p_organization_id => p_org_id, p_locator_id => p_locator_id);

3935: END IF;
3936: RAISE fnd_api.g_exc_unexpected_error;
3937: END;
3938:
3939: l_return_value := inv_projectlocator_pub.get_physical_location(p_organization_id => p_org_id, p_locator_id => p_locator_id);
3940:
3941: IF NOT l_return_value THEN
3942: IF (l_debug = 1) THEN
3943: DEBUG('GET_PHYSICAL_LOCATION: ERROR');

Line 5210: /AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)/

5206: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5207: AND b.subinventory_code = p_subinventory_code
5208: AND a.inventory_location_id = b.secondary_locator
5209: and a.organization_id = b.organization_id --13472820
5210: /*AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)*/
5211: AND a.alias = p_alias
5212: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_inventory_item_id, p_subinventory_code, a.inventory_location_id, NULL, NULL, 'L') = 'Y'
5213: ORDER BY 2;
5214: ELSE --Locators not restricted

Line 5224: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)

5220: FROM wms_item_locations_kfv
5221: WHERE organization_id = p_organization_id
5222: AND subinventory_code = p_subinventory_code
5223: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5224: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
5225: AND alias = p_alias
5226: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_inventory_item_id, p_subinventory_code, inventory_location_id, NULL, NULL, 'L') = 'Y'
5227: ORDER BY 2;
5228: END IF;

Line 5277: --AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)

5273: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5274: AND b.subinventory_code = p_subinventory_code
5275: AND a.inventory_location_id = b.secondary_locator
5276: and a.organization_id = b.organization_id --13472820
5277: --AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
5278: AND a.alias = p_alias
5279: AND a.project_id = p_project_id
5280: AND NVL(a.task_id, -1) = NVL(p_task_id, -1)
5281: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_inventory_item_id, p_subinventory_code, a.inventory_location_id, NULL, NULL, 'L') = 'Y'

Line 5293: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)

5289: FROM wms_item_locations_kfv
5290: WHERE organization_id = p_organization_id
5291: AND subinventory_code = p_subinventory_code
5292: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5293: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
5294: AND alias = p_alias
5295: AND project_id = p_project_id
5296: AND NVL(task_id, -1) = NVL(p_task_id, -1)
5297: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_inventory_item_id, p_subinventory_code, inventory_location_id, NULL, NULL, 'L') = 'Y'

Line 5343: /AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)/

5339: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5340: AND b.subinventory_code = p_subinventory_code
5341: AND a.inventory_location_id = b.secondary_locator
5342: and a.organization_id = b.organization_id --13472820
5343: /*AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)*/
5344: AND a.concatenated_segments LIKE (p_concatenated_segments)
5345: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_inventory_item_id, p_subinventory_code, a.inventory_location_id, NULL, NULL, 'L') = 'Y'
5346: ORDER BY 2;
5347: ELSE --Locators not restricted

Line 5357: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)

5353: FROM wms_item_locations_kfv
5354: WHERE organization_id = p_organization_id
5355: AND subinventory_code = p_subinventory_code
5356: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5357: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
5358: AND concatenated_segments LIKE (p_concatenated_segments)
5359: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_inventory_item_id, p_subinventory_code, inventory_location_id, NULL, NULL, 'L') = 'Y'
5360: ORDER BY 2;
5361: END IF;

Line 5410: --AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)

5406: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5407: AND b.subinventory_code = p_subinventory_code
5408: AND a.inventory_location_id = b.secondary_locator
5409: and a.organization_id = b.organization_id --13472820
5410: --AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
5411: AND a.concatenated_segments LIKE (p_concatenated_segments)
5412: AND a.project_id = p_project_id
5413: AND NVL(a.task_id, -1) = NVL(p_task_id, -1)
5414: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_inventory_item_id, p_subinventory_code, a.inventory_location_id, NULL, NULL, 'L') = 'Y'

Line 5426: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)

5422: FROM wms_item_locations_kfv
5423: WHERE organization_id = p_organization_id
5424: AND subinventory_code = p_subinventory_code
5425: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5426: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
5427: AND concatenated_segments LIKE (p_concatenated_segments)
5428: AND project_id = p_project_id
5429: AND NVL(task_id, -1) = NVL(p_task_id, -1)
5430: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_inventory_item_id, p_subinventory_code, inventory_location_id, NULL, NULL, 'L') = 'Y'

Line 5478: /AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)/

5474: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5475: AND b.subinventory_code = p_subinventory_code
5476: AND a.inventory_location_id = b.secondary_locator
5477: and a.organization_id = b.organization_id --13472820
5478: /*AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)*/
5479: AND a.concatenated_segments LIKE (p_concatenated_segments)
5480: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_inventory_item_id, p_subinventory_code, a.inventory_location_id, NULL, NULL, 'L') = 'Y'
5481: ORDER BY 2;
5482: ELSE --Locators not restricted

Line 5492: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)

5488: FROM wms_item_locations_kfv
5489: WHERE organization_id = p_organization_id
5490: AND subinventory_code = p_subinventory_code
5491: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5492: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
5493: AND concatenated_segments LIKE (p_concatenated_segments)
5494: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_inventory_item_id, p_subinventory_code, inventory_location_id, NULL, NULL, 'L') = 'Y'
5495: ORDER BY 2;
5496: END IF;

Line 5547: --AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)

5543: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5544: AND b.subinventory_code = p_subinventory_code
5545: AND a.inventory_location_id = b.secondary_locator
5546: and a.organization_id = b.organization_id --13472820
5547: --AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
5548: AND a.concatenated_segments LIKE (p_concatenated_segments)
5549: AND a.project_id = p_project_id
5550: AND NVL(a.task_id, -1) = NVL(p_task_id, -1)
5551: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_inventory_item_id, p_subinventory_code, a.inventory_location_id, NULL, NULL, 'L') = 'Y'

Line 5563: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)

5559: FROM wms_item_locations_kfv
5560: WHERE organization_id = p_organization_id
5561: AND subinventory_code = p_subinventory_code
5562: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5563: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
5564: AND concatenated_segments LIKE (p_concatenated_segments)
5565: AND project_id = p_project_id
5566: AND NVL(task_id, -1) = NVL(p_task_id, -1)
5567: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_inventory_item_id, p_subinventory_code, inventory_location_id, NULL, NULL, 'L') = 'Y'

Line 5624: /AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)/

5620: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5621: AND b.subinventory_code = p_subinventory_code
5622: AND a.inventory_location_id = b.secondary_locator
5623: and a.organization_id = b.organization_id --13472820
5624: /*AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)*/
5625: AND a.concatenated_segments LIKE (p_concatenated_segments)
5626: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_inventory_item_id, p_subinventory_code, a.inventory_location_id, NULL, NULL, 'L') = 'Y'
5627: ORDER BY 2;
5628: ELSE --Locators not restricted

Line 5639: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)

5635: FROM wms_item_locations_kfv
5636: WHERE organization_id = p_organization_id
5637: AND subinventory_code = p_subinventory_code
5638: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5639: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
5640: AND concatenated_segments LIKE (p_concatenated_segments)
5641: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_inventory_item_id, p_subinventory_code, inventory_location_id, NULL, NULL, 'L') = 'Y'
5642: ORDER BY 2;
5643: END IF;

Line 5660: /AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)/

5656: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5657: AND b.subinventory_code = p_subinventory_code
5658: AND a.inventory_location_id = b.secondary_locator
5659: and a.organization_id = b.organization_id --13472820
5660: /*AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)*/
5661: AND a.inventory_location_id=nvl(a.physical_location_id,a.inventory_location_id)
5662: AND a.concatenated_segments LIKE (p_concatenated_segments)
5663: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_inventory_item_id, p_subinventory_code, a.inventory_location_id, NULL, NULL, 'L') = 'Y'
5664: ORDER BY 2;

Line 5676: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)

5672: FROM wms_item_locations_kfv
5673: WHERE organization_id = p_organization_id
5674: AND subinventory_code = p_subinventory_code
5675: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5676: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
5677: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)
5678: AND concatenated_segments LIKE (p_concatenated_segments)
5679: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_inventory_item_id, p_subinventory_code, inventory_location_id, NULL, NULL, 'L') = 'Y'
5680: ORDER BY 2;

Line 5697: --AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)

5693: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5694: AND b.subinventory_code = p_subinventory_code
5695: AND a.inventory_location_id = b.secondary_locator
5696: and a.organization_id = b.organization_id --13472820
5697: --AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
5698: AND a.concatenated_segments LIKE (p_concatenated_segments)
5699: AND a.project_id = p_project_id
5700: AND NVL(a.task_id, -1) = NVL(p_task_id, -1)
5701: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_inventory_item_id, p_subinventory_code, a.inventory_location_id, NULL, NULL, 'L') = 'Y'

Line 5714: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)

5710: FROM wms_item_locations_kfv
5711: WHERE organization_id = p_organization_id
5712: AND subinventory_code = p_subinventory_code
5713: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5714: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
5715: AND concatenated_segments LIKE (p_concatenated_segments)
5716: AND project_id = p_project_id
5717: AND NVL(task_id, -1) = NVL(p_task_id, -1)
5718: AND inv_material_status_grp.is_status_applicable(p_wms_installed, NULL, p_transaction_type_id, NULL, NULL, p_organization_id, p_inventory_item_id, p_subinventory_code, inventory_location_id, NULL, NULL, 'L') = 'Y'