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 1158: * Use the function INV_PROJECT.get_locsegs() to retrieve the

1154: END;
1155:
1156: /* PJM-WMS Integration:Return only the the physical locators.
1157: * Use the table mtl_item_locations instead of mtl_item_locations_kfv.
1158: * Use the function INV_PROJECT.get_locsegs() to retrieve the
1159: * concatenated segments.Filter the locators based on the Project
1160: * and Task passed to the procedure.
1161: */
1162: PROCEDURE get_loc_with_status(x_locators OUT NOCOPY t_genref,

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

2240: description
2241: FROM wms_item_locations_kfv
2242: WHERE organization_id = p_organization_id
2243: AND subinventory_code = p_subinventory_code
2244: AND concatenated_segments LIKE (p_concatenated_segments )-- inv_project.get_locsegs(inventory_location_id,organization_id) LIKE (p_concatenated_segments || '%')
2245: AND project_id = p_project_id
2246: AND task_id = p_task_id
2247: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE) -- bug # 4866575
2248: AND (INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,

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

2268: description
2269: FROM wms_item_locations_kfv
2270: WHERE organization_id = p_organization_id
2271: AND subinventory_code = p_subinventory_code
2272: AND concatenated_segments LIKE (p_concatenated_segments )--inv_project.get_locsegs(inventory_location_id,organization_id) LIKE (p_concatenated_segments || '%')
2273: AND project_id = p_project_id
2274: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE) -- bug # 4866575
2275: AND (INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
2276: NULL,

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

2296: description
2297: FROM wms_item_locations_kfv
2298: WHERE organization_id = p_organization_id
2299: AND subinventory_code = p_subinventory_code
2300: AND concatenated_segments LIKE (p_concatenated_segments )-- inv_project.get_locsegs(inventory_location_id,organization_id) LIKE (p_concatenated_segments || '%')
2301: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE) -- bug # 4866575
2302: AND (INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
2303: NULL,
2304: 4,

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

2457: FROM wms_item_locations_kfv
2458: WHERE organization_id = p_organization_id
2459: AND subinventory_code = p_subinventory_code
2460: AND alias = p_alias
2461: --inv_project.get_locsegs(inventory_location_id,organization_id) LIKE (p_concatenated_segments || '%')
2462: AND project_id = p_project_id
2463: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE) -- bug # 4866575
2464: AND (INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
2465: NULL,

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

2486: FROM wms_item_locations_kfv
2487: WHERE organization_id = p_organization_id
2488: AND subinventory_code = p_subinventory_code
2489: AND alias = p_alias
2490: -- inv_project.get_locsegs(inventory_location_id,organization_id) LIKE (p_concatenated_segments || '%')
2491: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE) -- bug # 4866575
2492: AND (INV_MATERIAL_STATUS_GRP.is_status_applicable(NULL,
2493: NULL,
2494: 4,

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

2525: , a.subinventory_code
2526: , NVL(a.locator_id, 0)
2527: , NVL(b.asset_inventory, '0')
2528: , 0
2529: , inv_project.get_locsegs(a.locator_id, p_organization_id)
2530: , inv_project.get_project_id
2531: , inv_project.get_project_number
2532: , inv_project.get_task_id
2533: , inv_project.get_task_number

Line 2530: , inv_project.get_project_id

2526: , NVL(a.locator_id, 0)
2527: , NVL(b.asset_inventory, '0')
2528: , 0
2529: , inv_project.get_locsegs(a.locator_id, p_organization_id)
2530: , inv_project.get_project_id
2531: , inv_project.get_project_number
2532: , inv_project.get_task_id
2533: , inv_project.get_task_number
2534: FROM wms_license_plate_numbers a, mtl_secondary_inventories b

Line 2531: , inv_project.get_project_number

2527: , NVL(b.asset_inventory, '0')
2528: , 0
2529: , inv_project.get_locsegs(a.locator_id, p_organization_id)
2530: , inv_project.get_project_id
2531: , inv_project.get_project_number
2532: , inv_project.get_task_id
2533: , inv_project.get_task_number
2534: FROM wms_license_plate_numbers a, mtl_secondary_inventories b
2535: WHERE a.organization_id = p_organization_id

Line 2532: , inv_project.get_task_id

2528: , 0
2529: , inv_project.get_locsegs(a.locator_id, p_organization_id)
2530: , inv_project.get_project_id
2531: , inv_project.get_project_number
2532: , inv_project.get_task_id
2533: , inv_project.get_task_number
2534: FROM wms_license_plate_numbers a, mtl_secondary_inventories b
2535: WHERE a.organization_id = p_organization_id
2536: AND (a.lpn_context = 1 OR a.lpn_context = 11)

Line 2533: , inv_project.get_task_number

2529: , inv_project.get_locsegs(a.locator_id, p_organization_id)
2530: , inv_project.get_project_id
2531: , inv_project.get_project_number
2532: , inv_project.get_task_id
2533: , inv_project.get_task_number
2534: FROM wms_license_plate_numbers a, mtl_secondary_inventories b
2535: WHERE a.organization_id = p_organization_id
2536: AND (a.lpn_context = 1 OR a.lpn_context = 11)
2537: AND b.organization_id(+) = a.organization_id

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

2578: , a.subinventory_code
2579: , NVL(a.locator_id, 0)
2580: , NVL(b.asset_inventory, '0')
2581: , 0
2582: , inv_project.get_locsegs(a.locator_id, p_organization_id)
2583: , inv_project.get_project_id
2584: , inv_project.get_project_number
2585: , inv_project.get_task_id
2586: , inv_project.get_task_number

Line 2583: , inv_project.get_project_id

2579: , NVL(a.locator_id, 0)
2580: , NVL(b.asset_inventory, '0')
2581: , 0
2582: , inv_project.get_locsegs(a.locator_id, p_organization_id)
2583: , inv_project.get_project_id
2584: , inv_project.get_project_number
2585: , inv_project.get_task_id
2586: , inv_project.get_task_number
2587: FROM wms_license_plate_numbers a, mtl_secondary_inventories b

Line 2584: , inv_project.get_project_number

2580: , NVL(b.asset_inventory, '0')
2581: , 0
2582: , inv_project.get_locsegs(a.locator_id, p_organization_id)
2583: , inv_project.get_project_id
2584: , inv_project.get_project_number
2585: , inv_project.get_task_id
2586: , inv_project.get_task_number
2587: FROM wms_license_plate_numbers a, mtl_secondary_inventories b
2588: WHERE a.organization_id = p_organization_id

Line 2585: , inv_project.get_task_id

2581: , 0
2582: , inv_project.get_locsegs(a.locator_id, p_organization_id)
2583: , inv_project.get_project_id
2584: , inv_project.get_project_number
2585: , inv_project.get_task_id
2586: , inv_project.get_task_number
2587: FROM wms_license_plate_numbers a, mtl_secondary_inventories b
2588: WHERE a.organization_id = p_organization_id
2589: AND (a.lpn_context = 1 OR a.lpn_context = 11)

Line 2586: , inv_project.get_task_number

2582: , inv_project.get_locsegs(a.locator_id, p_organization_id)
2583: , inv_project.get_project_id
2584: , inv_project.get_project_number
2585: , inv_project.get_task_id
2586: , inv_project.get_task_number
2587: FROM wms_license_plate_numbers a, mtl_secondary_inventories b
2588: WHERE a.organization_id = p_organization_id
2589: AND (a.lpn_context = 1 OR a.lpn_context = 11)
2590: AND b.organization_id(+) = a.organization_id

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

3240: -- cycle count
3241: --
3242: /* PJM-WMS Integration:Return only the the physical locators.
3243: * Use the table mtl_item_locations instead of mtl_item_locations_kfv.
3244: * Use the function INV_PROJECT.get_locsegs() to retrieve the
3245: * concatenated segments.
3246: */
3247: 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
3248: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

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

3523: -- we call the PJM Locator API to create the physical locator.
3524: -- This happens only if the physical locator does not already
3525: -- exist.
3526: --
3527: l_return_value := inv_projectlocator_pub.get_physical_location(p_organization_id => p_org_id, p_locator_id => p_locator_id);
3528:
3529: IF NOT l_return_value THEN
3530: IF (l_debug = 1) THEN
3531: DEBUG('GET_PHYSICAL_LOCATION: ERROR');

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

4748: AND b.inventory_item_id = p_inventory_item_id
4749: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4750: AND b.subinventory_code = p_subinventory_code
4751: AND a.inventory_location_id = b.secondary_locator
4752: /*AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)*/
4753: AND a.alias = p_alias
4754: 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'
4755: ORDER BY 2;
4756: ELSE --Locators not restricted

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

4762: FROM wms_item_locations_kfv
4763: WHERE organization_id = p_organization_id
4764: AND subinventory_code = p_subinventory_code
4765: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4766: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
4767: AND alias = p_alias
4768: 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'
4769: ORDER BY 2;
4770: END IF;

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

4813: AND b.inventory_item_id = p_inventory_item_id
4814: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4815: AND b.subinventory_code = p_subinventory_code
4816: AND a.inventory_location_id = b.secondary_locator
4817: --AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
4818: AND a.alias = p_alias
4819: AND a.project_id = p_project_id
4820: AND NVL(a.task_id, -1) = NVL(p_task_id, -1)
4821: 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 4833: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)

4829: FROM wms_item_locations_kfv
4830: WHERE organization_id = p_organization_id
4831: AND subinventory_code = p_subinventory_code
4832: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4833: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
4834: AND alias = p_alias
4835: AND project_id = p_project_id
4836: AND NVL(task_id, -1) = NVL(p_task_id, -1)
4837: 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 4882: /AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)/

4878: AND b.inventory_item_id = p_inventory_item_id
4879: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4880: AND b.subinventory_code = p_subinventory_code
4881: AND a.inventory_location_id = b.secondary_locator
4882: /*AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)*/
4883: AND a.concatenated_segments LIKE (p_concatenated_segments)
4884: 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'
4885: ORDER BY 2;
4886: ELSE --Locators not restricted

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

4892: FROM wms_item_locations_kfv
4893: WHERE organization_id = p_organization_id
4894: AND subinventory_code = p_subinventory_code
4895: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4896: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
4897: AND concatenated_segments LIKE (p_concatenated_segments)
4898: 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'
4899: ORDER BY 2;
4900: END IF;

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

4943: AND b.inventory_item_id = p_inventory_item_id
4944: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4945: AND b.subinventory_code = p_subinventory_code
4946: AND a.inventory_location_id = b.secondary_locator
4947: --AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
4948: AND a.concatenated_segments LIKE (p_concatenated_segments)
4949: AND a.project_id = p_project_id
4950: AND NVL(a.task_id, -1) = NVL(p_task_id, -1)
4951: 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 4963: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)

4959: FROM wms_item_locations_kfv
4960: WHERE organization_id = p_organization_id
4961: AND subinventory_code = p_subinventory_code
4962: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4963: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
4964: AND concatenated_segments LIKE (p_concatenated_segments)
4965: AND project_id = p_project_id
4966: AND NVL(task_id, -1) = NVL(p_task_id, -1)
4967: 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 5014: /AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)/

5010: AND b.inventory_item_id = p_inventory_item_id
5011: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5012: AND b.subinventory_code = p_subinventory_code
5013: AND a.inventory_location_id = b.secondary_locator
5014: /*AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)*/
5015: AND a.concatenated_segments LIKE (p_concatenated_segments)
5016: 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'
5017: ORDER BY 2;
5018: ELSE --Locators not restricted

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

5024: FROM wms_item_locations_kfv
5025: WHERE organization_id = p_organization_id
5026: AND subinventory_code = p_subinventory_code
5027: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5028: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
5029: AND concatenated_segments LIKE (p_concatenated_segments)
5030: 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'
5031: ORDER BY 2;
5032: END IF;

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

5077: AND b.inventory_item_id = p_inventory_item_id
5078: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5079: AND b.subinventory_code = p_subinventory_code
5080: AND a.inventory_location_id = b.secondary_locator
5081: --AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
5082: AND a.concatenated_segments LIKE (p_concatenated_segments)
5083: AND a.project_id = p_project_id
5084: AND NVL(a.task_id, -1) = NVL(p_task_id, -1)
5085: 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 5097: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)

5093: FROM wms_item_locations_kfv
5094: WHERE organization_id = p_organization_id
5095: AND subinventory_code = p_subinventory_code
5096: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5097: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
5098: AND concatenated_segments LIKE (p_concatenated_segments)
5099: AND project_id = p_project_id
5100: AND NVL(task_id, -1) = NVL(p_task_id, -1)
5101: 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 5157: /AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)/

5153: AND b.inventory_item_id = p_inventory_item_id
5154: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5155: AND b.subinventory_code = p_subinventory_code
5156: AND a.inventory_location_id = b.secondary_locator
5157: /*AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)*/
5158: AND a.concatenated_segments LIKE (p_concatenated_segments)
5159: 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'
5160: ORDER BY 2;
5161: ELSE --Locators not restricted

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

5168: FROM wms_item_locations_kfv
5169: WHERE organization_id = p_organization_id
5170: AND subinventory_code = p_subinventory_code
5171: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5172: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
5173: AND concatenated_segments LIKE (p_concatenated_segments)
5174: 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'
5175: ORDER BY 2;
5176: END IF;

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

5188: AND b.inventory_item_id = p_inventory_item_id
5189: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5190: AND b.subinventory_code = p_subinventory_code
5191: AND a.inventory_location_id = b.secondary_locator
5192: /*AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)*/
5193: AND a.inventory_location_id=nvl(a.physical_location_id,a.inventory_location_id)
5194: AND a.concatenated_segments LIKE (p_concatenated_segments)
5195: 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'
5196: ORDER BY 2;

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

5204: FROM wms_item_locations_kfv
5205: WHERE organization_id = p_organization_id
5206: AND subinventory_code = p_subinventory_code
5207: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5208: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
5209: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)
5210: AND concatenated_segments LIKE (p_concatenated_segments)
5211: 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'
5212: ORDER BY 2;

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

5224: AND b.inventory_item_id = p_inventory_item_id
5225: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5226: AND b.subinventory_code = p_subinventory_code
5227: AND a.inventory_location_id = b.secondary_locator
5228: --AND inv_project.get_locsegs(a.inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
5229: AND a.concatenated_segments LIKE (p_concatenated_segments)
5230: AND a.project_id = p_project_id
5231: AND NVL(a.task_id, -1) = NVL(p_task_id, -1)
5232: 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 5245: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)

5241: FROM wms_item_locations_kfv
5242: WHERE organization_id = p_organization_id
5243: AND subinventory_code = p_subinventory_code
5244: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5245: --AND inv_project.get_locsegs(inventory_location_id, p_organization_id) LIKE (p_concatenated_segments)
5246: AND concatenated_segments LIKE (p_concatenated_segments)
5247: AND project_id = p_project_id
5248: AND NVL(task_id, -1) = NVL(p_task_id, -1)
5249: 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'