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 WMS_ITEM_LOCATIONS_KFV

Line 829: FROM wms_item_locations_kfv a, mtl_secondary_locators b

825: SELECT a.inventory_location_id
826: --, a.concatenated_segments----Bug4398337:Commented this line and added below line
827: , a.locator_segments concatenated_segments
828: , a.description
829: FROM wms_item_locations_kfv a, mtl_secondary_locators b
830: WHERE b.organization_id = p_organization_id
831: AND b.inventory_item_id = p_inventory_item_id
832: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
833: AND b.subinventory_code = p_subinventory_code

Line 845: FROM wms_item_locations_kfv

841: SELECT inventory_location_id
842: -- , concatenated_segments--Bug4398337:Commented this line and added below line
843: , locator_segments concatenated_segments
844: , description
845: FROM wms_item_locations_kfv
846: WHERE organization_id = p_organization_id
847: AND subinventory_code = p_subinventory_code
848: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
849: AND concatenated_segments LIKE (p_concatenated_segments)

Line 896: FROM wms_item_locations_kfv a, mtl_secondary_locators b

892: SELECT a.inventory_location_id
893: --, a.concatenated_segments concatenated_segments--Bug4398337:Commented this line and added below line
894: , a.locator_segments concatenated_segments
895: , a.description
896: FROM wms_item_locations_kfv a, mtl_secondary_locators b
897: WHERE b.organization_id = p_organization_id
898: AND b.inventory_item_id = p_inventory_item_id
899: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
900: AND b.subinventory_code = p_subinventory_code

Line 915: FROM wms_item_locations_kfv

911: SELECT inventory_location_id
912: --, concatenated_segments concatenated_segments--Bug4398337:Commented this line and added below line
913: , locator_segments concatenated_segments
914: , description
915: FROM wms_item_locations_kfv
916: WHERE organization_id = p_organization_id
917: AND subinventory_code = p_subinventory_code
918: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
919: AND concatenated_segments LIKE (p_concatenated_segments)

Line 959: FROM wms_item_locations_kfv a,

955: SELECT a.inventory_location_id,
956: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
957: a.locator_segments locsegs,
958: a.description
959: FROM wms_item_locations_kfv a,
960: mtl_secondary_locators b
961: WHERE b.organization_id = p_Organization_Id
962: AND b.inventory_item_id = p_Inventory_Item_Id
963: AND b.subinventory_code = p_Subinventory_Code

Line 979: FROM wms_item_locations_kfv

975: SELECT inventory_location_id,
976: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
977: locator_segments locsegs,
978: description
979: FROM wms_item_locations_kfv
980: WHERE organization_id = Nvl(p_organization_id, organization_id)
981: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
982: and nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate) /* 2915024 */
983: AND concatenated_segments LIKE (p_concatenated_segments)

Line 991: FROM wms_item_locations_kfv

987: SELECT inventory_location_id,
988: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
989: locator_segments locsegs,
990: description
991: FROM wms_item_locations_kfv
992: WHERE organization_id = p_organization_id
993: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
994: and nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate) /* 2915024 */
995: AND concatenated_segments LIKE (p_concatenated_segments)

Line 1006: FROM wms_item_locations_kfv a,

1002: SELECT a.inventory_location_id,
1003: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
1004: a.locator_segments locsegs,
1005: a.description
1006: FROM wms_item_locations_kfv a,
1007: mtl_secondary_locators b
1008: WHERE b.organization_id = p_Organization_Id
1009: AND b.inventory_item_id = p_Inventory_Item_Id
1010: AND b.subinventory_code = p_Subinventory_Code

Line 1025: FROM wms_item_locations_kfv

1021: SELECT inventory_location_id,
1022: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
1023: locator_segments locsegs,
1024: description
1025: FROM wms_item_locations_kfv
1026: WHERE organization_id = Nvl(p_organization_id, organization_id)
1027: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
1028: and nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate) /* 2915024 */
1029: AND concatenated_segments LIKE (p_concatenated_segments )

Line 1038: FROM wms_item_locations_kfv

1034: SELECT inventory_location_id,
1035: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
1036: locator_segments locsegs,
1037: description
1038: FROM wms_item_locations_kfv
1039: WHERE organization_id = p_organization_id
1040: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
1041: and nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate) /* 2915024 */
1042: AND concatenated_segments LIKE (p_concatenated_segments )

Line 1093: FROM wms_item_locations_kfv a,

1089: SELECT a.inventory_location_id,
1090: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
1091: a.locator_segments locsegs,
1092: a.description
1093: FROM wms_item_locations_kfv a,
1094: mtl_secondary_locators b
1095: WHERE b.organization_id = p_Organization_Id
1096: AND b.inventory_item_id = p_Inventory_Item_Id
1097: AND b.subinventory_code = p_Subinventory_Code

Line 1113: FROM wms_item_locations_kfv

1109: SELECT inventory_location_id,
1110: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
1111: locator_segments locsegs,
1112: description
1113: FROM wms_item_locations_kfv
1114: WHERE organization_id = Nvl(p_organization_id, organization_id)
1115: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
1116: and nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate) /* 2915024 */
1117: AND alias = p_alias

Line 1125: FROM wms_item_locations_kfv

1121: SELECT inventory_location_id,
1122: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
1123: locator_segments locsegs,
1124: description
1125: FROM wms_item_locations_kfv
1126: WHERE organization_id = p_organization_id
1127: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
1128: and nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate) /* 2915024 */
1129: AND alias = p_alias

Line 1140: FROM wms_item_locations_kfv a,

1136: SELECT a.inventory_location_id,
1137: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
1138: a.locator_segments locsegs,
1139: a.description
1140: FROM wms_item_locations_kfv a,
1141: mtl_secondary_locators b
1142: WHERE b.organization_id = p_Organization_Id
1143: AND b.inventory_item_id = p_Inventory_Item_Id
1144: AND b.subinventory_code = p_Subinventory_Code

Line 1159: FROM wms_item_locations_kfv

1155: SELECT inventory_location_id,
1156: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
1157: locator_segments locsegs,
1158: description
1159: FROM wms_item_locations_kfv
1160: WHERE organization_id = Nvl(p_organization_id, organization_id)
1161: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
1162: and nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate) /* 2915024 */
1163: AND alias = p_alias

Line 1172: FROM wms_item_locations_kfv

1168: SELECT inventory_location_id,
1169: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
1170: locator_segments locsegs,
1171: description
1172: FROM wms_item_locations_kfv
1173: WHERE organization_id = p_organization_id
1174: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
1175: and nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate) /* 2915024 */
1176: AND alias = p_alias

Line 1207: FROM wms_item_locations_kfv

1203: SELECT inventory_location_id
1204: , description
1205: INTO x_location_id
1206: , x_description
1207: FROM wms_item_locations_kfv
1208: WHERE organization_id = p_org_id
1209: AND subinventory_code = p_sub_code
1210: AND concatenated_segments = p_concat_segs
1211: AND ROWNUM < 2;

Line 1239: FROM wms_item_locations_kfv

1235: SELECT 'failed'
1236: INTO l_validity_check
1237: FROM DUAL
1238: WHERE EXISTS( SELECT subinventory_code
1239: FROM wms_item_locations_kfv
1240: WHERE concatenated_segments = p_concat_segs
1241: AND p_sub_code <> subinventory_code
1242: AND organization_id = p_org_id);
1243: EXCEPTION

Line 1417: FROM wms_item_locations_kfv mil

1413: SELECT mil.inventory_location_id
1414: --, mil.concatenated_segments conseg--Bug4398337:Commented this line and added below line
1415: , mil.locator_segments conseg
1416: , mil.description
1417: FROM wms_item_locations_kfv mil
1418: WHERE mil.organization_id = p_organization_id
1419: AND mil.inventory_location_id IN (SELECT from_locator_id
1420: FROM mtl_txn_request_lines
1421: WHERE header_id = p_moheader_id)

Line 1453: FROM wms_item_locations_kfv mil

1449: SELECT mil.inventory_location_id
1450: --, mil.concatenated_segments conseg--Bug4398337:Commented this line and added below line
1451: , mil.locator_segments conseg
1452: , mil.description
1453: FROM wms_item_locations_kfv mil
1454: WHERE mil.organization_id = p_organization_id
1455: AND mil.inventory_location_id IN (SELECT from_locator_id
1456: FROM mtl_txn_request_lines
1457: WHERE header_id = p_moheader_id)

Line 1483: FROM wms_item_locations_kfv mil

1479: SELECT mil.inventory_location_id
1480: --, mil.concatenated_segments consegs--Bug4398337:Commented this line and added below line
1481: , mil.locator_segments consegs
1482: , mil.description
1483: FROM wms_item_locations_kfv mil
1484: WHERE mil.organization_id = p_organization_id
1485: AND inventory_location_id IN (SELECT to_locator_id
1486: FROM mtl_txn_request_lines
1487: WHERE header_id = p_moheader_id)

Line 1521: FROM wms_item_locations_kfv mil

1517: OPEN x_locators FOR
1518: SELECT mil.inventory_location_id
1519: , mil.locator_segments conseg
1520: , mil.description
1521: FROM wms_item_locations_kfv mil
1522: WHERE mil.organization_id = p_organization_id
1523: AND mil.inventory_location_id IN (SELECT to_locator_id
1524: FROM mtl_txn_request_lines
1525: WHERE header_id = p_moheader_id)

Line 1553: FROM wms_item_locations_kfv mil, mtl_material_statuses_vl mmsv

1549: , mil.locator_segments concatenated_segments
1550: , mil.description
1551: , mil.status_id
1552: , mmsv.status_code
1553: FROM wms_item_locations_kfv mil, mtl_material_statuses_vl mmsv
1554: WHERE mil.organization_id = p_organization_id
1555: AND mil.subinventory_code = p_subinventory_code
1556: AND mil.concatenated_segments LIKE (p_concatenated_segments)
1557: AND mmsv.status_id = mil.status_id

Line 1592: FROM wms_item_locations_kfv mil, mtl_material_statuses_vl mmsv

1588: , mil.locator_segments concatenated_segments
1589: , mil.description
1590: , mil.status_id
1591: , mmsv.status_code
1592: FROM wms_item_locations_kfv mil, mtl_material_statuses_vl mmsv
1593: WHERE mil.organization_id = p_organization_id
1594: AND mil.subinventory_code = p_subinventory_code
1595: AND mil.alias = p_alias
1596: AND mmsv.status_id = mil.status_id

Line 2288: FROM wms_item_locations_kfv mil, mtl_physical_inventory_tags mpit

2284: SELECT UNIQUE mil.inventory_location_id
2285: --, mil.concatenated_segments--Bug4398337:Commented this line and added below line
2286: , mil.locator_segments concatenated_segments
2287: , mil.description
2288: FROM wms_item_locations_kfv mil, mtl_physical_inventory_tags mpit
2289: WHERE mil.organization_id = p_organization_id
2290: AND mil.subinventory_code = p_subinventory_code
2291: AND mil.concatenated_segments LIKE (p_concatenated_segments)
2292: AND mil.inventory_location_id = mpit.locator_id

Line 2314: FROM wms_item_locations_kfv mil

2310: SELECT inventory_location_id
2311: --, concatenated_segments--Bug4398337:Commented this line and added below line
2312: , locator_segments concatenated_segments
2313: , description
2314: FROM wms_item_locations_kfv mil
2315: WHERE organization_id = p_organization_id
2316: AND subinventory_code = p_subinventory_code
2317: AND concatenated_segments LIKE (p_concatenated_segments)
2318: -- WMS PJM Integration: Restrict Locators based on the project and task

Line 2362: FROM wms_item_locations_kfv mil, mtl_physical_inventory_tags mpit

2358: SELECT UNIQUE mil.inventory_location_id
2359: --, mil.concatenated_segments--Bug4398337:Commented this line and added below line
2360: , mil.locator_segments concatenated_segments
2361: , mil.description
2362: FROM wms_item_locations_kfv mil, mtl_physical_inventory_tags mpit
2363: WHERE mil.organization_id = p_organization_id
2364: AND mil.subinventory_code = p_subinventory_code
2365: AND mil.alias = p_alias
2366: AND mil.inventory_location_id = mpit.locator_id

Line 2388: FROM wms_item_locations_kfv mil

2384: SELECT inventory_location_id
2385: --, concatenated_segments--Bug4398337:Commented this line and added below line
2386: , locator_segments concatenated_segments
2387: , description
2388: FROM wms_item_locations_kfv mil
2389: WHERE organization_id = p_organization_id
2390: AND subinventory_code = p_subinventory_code
2391: AND alias = p_alias
2392: -- WMS PJM Integration: Restrict Locators based on the project and task

Line 2578: FROM wms_item_locations_kfv mil, mtl_cycle_count_entries mcce

2574: SELECT UNIQUE mil.inventory_location_id,
2575: --mil.concatenated_segments concatenated_segments,--Bug4398337:Commented this line and added below line
2576: mil.locator_segments concatenated_segments,
2577: mil.description
2578: FROM wms_item_locations_kfv mil, mtl_cycle_count_entries mcce
2579: WHERE mcce.cycle_count_header_id = p_cycle_count_header_id
2580: AND mil.organization_id = p_organization_id
2581: AND mil.subinventory_code = p_subinventory_code
2582: AND NVL(mil.project_id,-1) = NVL(p_project_id,-1)

Line 2618: FROM wms_item_locations_kfv

2614: SELECT inventory_location_id,
2615: -- concatenated_segments, --Bug4398337:Commented this line and added below line
2616: locator_segments 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

Line 2646: FROM wms_item_locations_kfv

2642: SELECT inventory_location_id,
2643: -- concatenated_segments ,--Bug4398337:Commented this line and added below line
2644: locator_segments 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

Line 2674: FROM wms_item_locations_kfv

2670: SELECT inventory_location_id,
2671: -- concatenated_segments, --Bug4398337:Commented this line and added below line
2672: locator_segments 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

Line 2766: FROM wms_item_locations_kfv mil, mtl_cycle_count_entries mcce

2762: SELECT UNIQUE mil.inventory_location_id,
2763: --mil.concatenated_segments concatenated_segments,--Bug4398337:Commented this line and added below line
2764: mil.locator_segments concatenated_segments,
2765: mil.description
2766: FROM wms_item_locations_kfv mil, mtl_cycle_count_entries mcce
2767: WHERE mcce.cycle_count_header_id = p_cycle_count_header_id
2768: AND mil.organization_id = p_organization_id
2769: AND mil.subinventory_code = p_subinventory_code
2770: AND NVL(mil.project_id,-1) = NVL(p_project_id,-1)

Line 2806: FROM wms_item_locations_kfv

2802: SELECT inventory_location_id,
2803: -- concatenated_segments, --Bug4398337:Commented this line and added below line
2804: locator_segments concatenated_segments,
2805: description
2806: FROM wms_item_locations_kfv
2807: WHERE organization_id = p_organization_id
2808: AND subinventory_code = p_subinventory_code
2809: AND alias = p_alias
2810: AND project_id = p_project_id

Line 2834: FROM wms_item_locations_kfv

2830: SELECT inventory_location_id,
2831: -- concatenated_segments ,--Bug4398337:Commented this line and added below line
2832: locator_segments concatenated_segments,
2833: description
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 || '%')

Line 2863: FROM wms_item_locations_kfv

2859: SELECT inventory_location_id,
2860: -- concatenated_segments, --Bug4398337:Commented this line and added below line
2861: locator_segments concatenated_segments,
2862: description
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 || '%')

Line 3433: FROM wms_item_locations_kfv

3429: SELECT inventory_location_id
3430: --, concatenated_segments--Bug4398337:Commented this line and added below line
3431: , locator_segments concatenated_segments
3432: , description
3433: FROM wms_item_locations_kfv
3434: WHERE organization_id = p_organization_id
3435: AND subinventory_code = p_subinventory_code
3436: AND concatenated_segments LIKE (p_concatenated_segments)
3437: AND inv_ui_item_sub_loc_lovs.vaildate_lpn_toloc(p_lpn_id, p_subinventory_code, p_organization_id, inventory_location_id, p_wms_installed, p_transaction_type_id) = 'Y';

Line 3652: FROM wms_item_locations_kfv mil, MTL_ONHAND_QUANTITIES_DETAIL moq

3648: SELECT moq.locator_id
3649: --, mil.concatenated_segments--Bug4398337:Commented this line and added below line
3650: , mil.locator_segments concatenated_segments
3651: , mil.description
3652: FROM wms_item_locations_kfv mil, MTL_ONHAND_QUANTITIES_DETAIL moq
3653: WHERE mil.concatenated_segments LIKE (p_concatenated_segments)
3654: AND mil.inventory_location_id = moq.locator_id
3655: AND mil.organization_id = p_organization_id
3656: -- Bug 2325664 AND mil.physical_location_id is null -- PJM-WMS Integration

Line 3703: FROM wms_item_locations_kfv mil, MTL_ONHAND_QUANTITIES_DETAIL moq

3699: SELECT moq.locator_id
3700: --, mil.concatenated_segments--Bug4398337:Commented this line and added below line
3701: , mil.locator_segments concatenated_segments
3702: , mil.description
3703: FROM wms_item_locations_kfv mil, MTL_ONHAND_QUANTITIES_DETAIL moq
3704: WHERE alias = p_alias
3705: AND mil.inventory_location_id = moq.locator_id
3706: AND mil.organization_id = p_organization_id
3707: -- Bug 2325664 AND mil.physical_location_id is null -- PJM-WMS Integration

Line 3793: FROM wms_item_locations_kfv milv, mtl_material_statuses_tl mmsv

3789: , milv.locator_segments concatenated_segments
3790: , milv.description
3791: , 0 dummy
3792: , mmsv.status_code
3793: FROM wms_item_locations_kfv milv, mtl_material_statuses_tl mmsv
3794: WHERE milv.organization_id = p_organization_id
3795: AND milv.subinventory_code = p_subinventory_code
3796: AND milv.concatenated_segments LIKE (p_concatenated_segments)
3797: AND (mmsv.status_id(+)/*Added outer join 2918529*/ = milv.status_id )

Line 3839: FROM wms_item_locations_kfv milv, mtl_material_statuses_tl mmsv

3835: , milv.locator_segments concatenated_segments
3836: , milv.description
3837: , 0 dummy
3838: , mmsv.status_code
3839: FROM wms_item_locations_kfv milv, mtl_material_statuses_tl mmsv
3840: WHERE milv.organization_id = p_organization_id
3841: AND milv.subinventory_code = p_subinventory_code
3842: AND milv.alias = p_alias
3843: AND (mmsv.status_id(+)/*Added outer join 2918529*/ = milv.status_id )

Line 4094: FROM wms_item_locations_kfv a,mtl_secondary_locators b

4090: select a.inventory_location_id,
4091: --a.concatenated_segments,--Bug4398337:Commented this line and added below line
4092: a.locator_segments concatenated_segments,
4093: nvl( a.description, -1)
4094: FROM wms_item_locations_kfv a,mtl_secondary_locators b
4095: WHERE b.organization_id = p_Organization_Id
4096: AND b.inventory_item_id = p_Inventory_Item_Id
4097: AND nvl(a.disable_date, trunc(sysdate+1)) > trunc(sysdate)
4098: AND b.subinventory_code = p_Subinventory_Code

Line 4124: FROM wms_item_locations_kfv

4120: select inventory_location_id,
4121: --concatenated_segments,--Bug4398337:Commented this line and added below line
4122: locator_segments concatenated_segments,
4123: description
4124: FROM wms_item_locations_kfv
4125: WHERE organization_id = p_Organization_Id
4126: AND subinventory_code = p_Subinventory_Code
4127: AND nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate)
4128: AND concatenated_segments LIKE (p_concatenated_segments )

Line 4152: FROM wms_item_locations_kfv a,mtl_secondary_locators b

4148: select a.inventory_location_id,
4149: --a.concatenated_segments,--Bug4398337:Commented this line and added below line
4150: a.locator_segments concatenated_segments,
4151: nvl( a.description, -1)
4152: FROM wms_item_locations_kfv a,mtl_secondary_locators b
4153: WHERE b.organization_id = p_Organization_Id
4154: AND b.inventory_item_id = p_Inventory_Item_Id
4155: AND nvl(a.disable_date, trunc(sysdate+1)) > trunc(sysdate)
4156: AND b.subinventory_code = p_Subinventory_Code

Line 4183: FROM wms_item_locations_kfv

4179: select inventory_location_id,
4180: --concatenated_segments,--Bug4398337:Commented this line and added below line
4181: locator_segments concatenated_segments,
4182: description
4183: FROM wms_item_locations_kfv
4184: WHERE organization_id = p_Organization_Id
4185: AND subinventory_code = p_Subinventory_Code
4186: AND nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate)
4187: AND inventory_location_id=NVL(physical_location_id,inventory_location_id)

Line 4279: FROM wms_item_locations_kfv a,mtl_secondary_locators b

4275: select a.inventory_location_id,
4276: --a.concatenated_segments,--Bug4398337:Commented this line and added below line
4277: a.locator_segments concatenated_segments,
4278: nvl( a.description, -1)
4279: FROM wms_item_locations_kfv a,mtl_secondary_locators b
4280: WHERE b.organization_id = p_Organization_Id
4281: AND b.inventory_item_id = p_Inventory_Item_Id
4282: AND nvl(a.disable_date, trunc(sysdate+1)) > trunc(sysdate)
4283: AND b.subinventory_code = p_Subinventory_Code

Line 4310: FROM wms_item_locations_kfv

4306: select inventory_location_id,
4307: --concatenated_segments,--Bug4398337:Commented this line and added below line
4308: locator_segments concatenated_segments,
4309: description
4310: FROM wms_item_locations_kfv
4311: WHERE organization_id = p_Organization_Id
4312: AND subinventory_code = p_Subinventory_Code
4313: AND nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate)
4314: -- AND concatenated_segments LIKE (p_concatenated_segments )

Line 4339: FROM wms_item_locations_kfv a,mtl_secondary_locators b

4335: select a.inventory_location_id,
4336: --a.concatenated_segments,--Bug4398337:Commented this line and added below line
4337: a.locator_segments concatenated_segments,
4338: nvl( a.description, -1)
4339: FROM wms_item_locations_kfv a,mtl_secondary_locators b
4340: WHERE b.organization_id = p_Organization_Id
4341: AND b.inventory_item_id = p_Inventory_Item_Id
4342: AND nvl(a.disable_date, trunc(sysdate+1)) > trunc(sysdate)
4343: AND b.subinventory_code = p_Subinventory_Code

Line 4371: FROM wms_item_locations_kfv

4367: select inventory_location_id,
4368: --concatenated_segments,--Bug4398337:Commented this line and added below line
4369: locator_segments concatenated_segments,
4370: description
4371: FROM wms_item_locations_kfv
4372: WHERE organization_id = p_Organization_Id
4373: AND subinventory_code = p_Subinventory_Code
4374: AND nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate)
4375: AND inventory_location_id=NVL(physical_location_id,inventory_location_id)

Line 4560: FROM wms_item_locations_kfv

4556: SELECT inventory_location_id
4557: --, concatenated_segments--Bug4398337:Commented this line and added below line
4558: , locator_segments concatenated_segments
4559: , description
4560: FROM wms_item_locations_kfv
4561: WHERE organization_id = p_organization_id
4562: AND subinventory_code = p_subinventory_code
4563: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4564: AND concatenated_segments LIKE (p_concatenated_segments)

Line 4603: FROM wms_item_locations_kfv

4599: SELECT inventory_location_id
4600: --, concatenated_segments--Bug4398337:Commented this line and added below line
4601: , locator_segments concatenated_segments
4602: , description
4603: FROM wms_item_locations_kfv
4604: WHERE organization_id = p_organization_id
4605: AND subinventory_code = p_subinventory_code
4606: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4607: AND alias = p_alias

Line 4984: FROM wms_item_locations_kfv

4980: -- , concatenated_segments--Bug4398337:Commented this line and added below line
4981: , locator_segments concatenated_segments
4982: , description
4983: , inventory_location_type
4984: FROM wms_item_locations_kfv
4985: WHERE organization_id = p_organization_id
4986: AND subinventory_code = p_subinventory_code
4987: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4988: AND alias = p_alias

Line 5014: FROM wms_item_locations_kfv

5010: -- , concatenated_segments--Bug4398337:Commented this line and added below line
5011: , locator_segments concatenated_segments
5012: , description
5013: , inventory_location_type
5014: FROM wms_item_locations_kfv
5015: WHERE organization_id = p_organization_id
5016: AND subinventory_code = p_subinventory_code
5017: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5018: AND concatenated_segments LIKE (p_concatenated_segments)

Line 5203: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5199: SELECT a.inventory_location_id
5200: --, a.concatenated_segments--Bug4398337:Commented this line and added below line
5201: , a.locator_segments
5202: , NVL(a.description, -1)
5203: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5204: WHERE b.organization_id = p_organization_id
5205: AND b.inventory_item_id = p_inventory_item_id
5206: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5207: AND b.subinventory_code = p_subinventory_code

Line 5220: FROM wms_item_locations_kfv

5216: SELECT inventory_location_id
5217: --, concatenated_segments--Bug4398337:Commented this line and added below line
5218: , locator_segments concatenated_segments
5219: , description
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)

Line 5237: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5233: SELECT a.inventory_location_id
5234: --, a.concatenated_segments--Bug4398337:Commented this line and added below line
5235: , a.locator_segments concatenated_segments
5236: , NVL(a.description, -1)
5237: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5238: WHERE b.organization_id = p_organization_id
5239: AND b.inventory_item_id = p_inventory_item_id
5240: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5241: AND b.subinventory_code = p_subinventory_code

Line 5254: FROM wms_item_locations_kfv

5250: SELECT inventory_location_id
5251: --, concatenated_segments--Bug4398337:Commented this line and added below line
5252: , locator_segments concatenated_segments
5253: , description
5254: FROM wms_item_locations_kfv
5255: WHERE organization_id = p_organization_id
5256: AND subinventory_code = p_subinventory_code
5257: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5258: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)

Line 5270: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5266: SELECT a.inventory_location_id
5267: --, a.concatenated_segments--Bug4398337:Commented this line and added below line
5268: , a.locator_segments concatenated_segments
5269: , NVL(a.description, -1)
5270: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5271: WHERE b.organization_id = p_organization_id
5272: AND b.inventory_item_id = p_inventory_item_id
5273: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5274: AND b.subinventory_code = p_subinventory_code

Line 5289: FROM wms_item_locations_kfv

5285: SELECT inventory_location_id
5286: --, concatenated_segments--Bug4398337:Commented this line and added below line
5287: , locator_segments concatenated_segments
5288: , description
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)

Line 5336: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5332: SELECT a.inventory_location_id
5333: --, a.concatenated_segments--Bug4398337:Commented this line and added below line
5334: , a.locator_segments
5335: , NVL(a.description, -1)
5336: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5337: WHERE b.organization_id = p_organization_id
5338: AND b.inventory_item_id = p_inventory_item_id
5339: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5340: AND b.subinventory_code = p_subinventory_code

Line 5353: FROM wms_item_locations_kfv

5349: SELECT inventory_location_id
5350: --, concatenated_segments--Bug4398337:Commented this line and added below line
5351: , locator_segments concatenated_segments
5352: , description
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)

Line 5370: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5366: SELECT a.inventory_location_id
5367: --, a.concatenated_segments--Bug4398337:Commented this line and added below line
5368: , a.locator_segments concatenated_segments
5369: , NVL(a.description, -1)
5370: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5371: WHERE b.organization_id = p_organization_id
5372: AND b.inventory_item_id = p_inventory_item_id
5373: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5374: AND b.subinventory_code = p_subinventory_code

Line 5387: FROM wms_item_locations_kfv

5383: SELECT inventory_location_id
5384: --, concatenated_segments--Bug4398337:Commented this line and added below line
5385: , locator_segments concatenated_segments
5386: , description
5387: FROM wms_item_locations_kfv
5388: WHERE organization_id = p_organization_id
5389: AND subinventory_code = p_subinventory_code
5390: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5391: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)

Line 5403: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5399: SELECT a.inventory_location_id
5400: --, a.concatenated_segments--Bug4398337:Commented this line and added below line
5401: , a.locator_segments concatenated_segments
5402: , NVL(a.description, -1)
5403: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5404: WHERE b.organization_id = p_organization_id
5405: AND b.inventory_item_id = p_inventory_item_id
5406: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5407: AND b.subinventory_code = p_subinventory_code

Line 5422: FROM wms_item_locations_kfv

5418: SELECT inventory_location_id
5419: --, concatenated_segments--Bug4398337:Commented this line and added below line
5420: , locator_segments concatenated_segments
5421: , description
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)

Line 5471: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5467: SELECT a.inventory_location_id
5468: , a.concatenated_segments -- Bug 4398336
5469: --, a.locator_segments concatenated_segments
5470: , NVL(a.description, -1)
5471: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5472: WHERE b.organization_id = p_organization_id
5473: AND b.inventory_item_id = p_inventory_item_id
5474: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5475: AND b.subinventory_code = p_subinventory_code

Line 5488: FROM wms_item_locations_kfv

5484: SELECT inventory_location_id
5485: , concatenated_segments -- Bug 4398336
5486: --, locator_segments concatenated_segments
5487: , description
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)

Line 5505: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5501: SELECT a.inventory_location_id
5502: , a.concatenated_segments -- Bug 4398336
5503: --, a.locator_segments concatenated_segments
5504: , NVL(a.description, -1)
5505: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5506: WHERE b.organization_id = p_organization_id
5507: AND b.inventory_item_id = p_inventory_item_id
5508: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5509: AND b.subinventory_code = p_subinventory_code

Line 5523: FROM wms_item_locations_kfv

5519: SELECT inventory_location_id
5520: , concatenated_segments -- Bug 4398336
5521: --, locator_segments concatenated_segments
5522: , description
5523: FROM wms_item_locations_kfv
5524: WHERE organization_id = p_organization_id
5525: AND subinventory_code = p_subinventory_code
5526: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5527: -- AND inventory_location_id=nvl(physical_location_id,inventory_location_id)

Line 5540: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5536: SELECT a.inventory_location_id
5537: , a.concatenated_segments -- Bug 4398336
5538: --, a.locator_segments concatenated_segments
5539: , NVL(a.description, -1)
5540: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5541: WHERE b.organization_id = p_organization_id
5542: AND b.inventory_item_id = p_inventory_item_id
5543: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5544: AND b.subinventory_code = p_subinventory_code

Line 5559: FROM wms_item_locations_kfv

5555: SELECT inventory_location_id
5556: , concatenated_segments -- Bug 4398336
5557: --, locator_segments concatenated_segments
5558: , description
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)

Line 5617: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5613: --, a.concatenated_segments--Bug4398337:Commented this line and added below line
5614: , a.locator_segments concatenated_segments
5615: , NVL(a.description, -1)
5616: , a.subinventory_code
5617: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5618: WHERE b.organization_id = p_organization_id
5619: AND b.inventory_item_id = p_inventory_item_id
5620: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5621: AND b.subinventory_code = p_subinventory_code

Line 5635: FROM wms_item_locations_kfv

5631: -- , concatenated_segments--Bug4398337:Commented this line and added below line
5632: , locator_segments concatenated_segments
5633: , description
5634: , subinventory_code
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)

Line 5653: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5649: --, a.concatenated_segments--Bug4398337:Commented this line and added below line
5650: , a.locator_segments concatenated_segments
5651: , NVL(a.description, -1)
5652: , a.subinventory_code
5653: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5654: WHERE b.organization_id = p_organization_id
5655: AND b.inventory_item_id = p_inventory_item_id
5656: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5657: AND b.subinventory_code = p_subinventory_code

Line 5672: FROM wms_item_locations_kfv

5668: -- , concatenated_segments--Bug4398337:Commented this line and added below line
5669: , locator_segments concatenated_segments
5670: , description
5671: , subinventory_code
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)

Line 5690: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5686: --, a.concatenated_segments--Bug4398337:Commented this line and added below line
5687: , a.locator_segments concatenated_segments
5688: , NVL(a.description, -1)
5689: , a.subinventory_code
5690: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5691: WHERE b.organization_id = p_organization_id
5692: AND b.inventory_item_id = p_inventory_item_id
5693: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5694: AND b.subinventory_code = p_subinventory_code

Line 5710: FROM wms_item_locations_kfv

5706: -- , concatenated_segments--Bug4398337:Commented this line and added below line
5707: , locator_segments concatenated_segments
5708: , description
5709: , subinventory_code
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)

Line 5771: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5767: -- , a.concatenated_segments--Bug4398337:Commented this line and added below line
5768: , a.locator_segments concatenated_segments
5769: , NVL(a.description, -1)
5770: , a.subinventory_code
5771: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5772: WHERE b.organization_id = p_organization_id
5773: AND b.inventory_item_id = p_inventory_item_id
5774: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5775: /*AND b.subinventory_code = p_subinventory_code*/ /*Removed Subinventory restriction, displayes all locs in the org*/

Line 5788: FROM wms_item_locations_kfv

5784: --, concatenated_segments--Bug4398337:Commented this line and added below line
5785: , locator_segments concatenated_segments
5786: , description
5787: , subinventory_code
5788: FROM wms_item_locations_kfv
5789: WHERE organization_id = p_organization_id
5790: /*AND subinventory_code = p_subinventory_code*//*Removed Subinventory restriction, displayes all locs in the org*/
5791: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5792: AND concatenated_segments LIKE (p_concatenated_segments)

Line 5805: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5801: -- , a.concatenated_segments--Bug4398337:Commented this line and added below line
5802: , a.locator_segments concatenated_segments
5803: , NVL(a.description, -1)
5804: ,a.subinventory_code
5805: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5806: WHERE b.organization_id = p_organization_id
5807: AND b.inventory_item_id = p_inventory_item_id
5808: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5809: /*AND b.subinventory_code = p_subinventory_code*//*Removed Subinventory restriction, displayes all locs in the org*/

Line 5823: FROM wms_item_locations_kfv

5819: -- , concatenated_segments--Bug4398337:Commented this line and added below line
5820: , locator_segments concatenated_segments
5821: , description
5822: , subinventory_code
5823: FROM wms_item_locations_kfv
5824: WHERE organization_id = p_organization_id
5825: /*AND subinventory_code = p_subinventory_code*//*Removed Subinventory restriction, displayes all locs in the org*/
5826: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5827: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)

Line 5840: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5836: -- , a.concatenated_segments--Bug4398337:Commented this line and added below line
5837: , a.locator_segments concatenated_segments
5838: , NVL(a.description, -1)
5839: , a.subinventory_code
5840: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5841: WHERE b.organization_id = p_organization_id
5842: AND b.inventory_item_id = p_inventory_item_id
5843: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5844: /*AND b.subinventory_code = p_subinventory_code*//*Removed Subinventory restriction, displayes all locs in the org*/

Line 5859: FROM wms_item_locations_kfv

5855: -- , concatenated_segments--Bug4398337:Commented this line and added below line
5856: , locator_segments concatenated_segments
5857: , description
5858: , subinventory_code
5859: FROM wms_item_locations_kfv
5860: WHERE organization_id = p_organization_id
5861: /*AND subinventory_code = p_subinventory_code*//*Removed Subinventory restriction, displayes all locs in the org*/
5862: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5863: AND concatenated_segments LIKE (p_concatenated_segments)

Line 5963: FROM wms_item_locations_kfv a,

5959: SELECT a.inventory_location_id,
5960: -- a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5961: a.locator_segments locsegs,
5962: a.description
5963: FROM wms_item_locations_kfv a,
5964: mtl_secondary_locators b
5965: WHERE b.organization_id = p_Organization_Id
5966: AND b.inventory_item_id = p_Inventory_Item_Id
5967: AND b.subinventory_code = p_Subinventory_Code

Line 5982: FROM wms_item_locations_kfv

5978: SELECT inventory_location_id,
5979: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5980: locator_segments locsegs,
5981: description
5982: FROM wms_item_locations_kfv
5983: WHERE organization_id = Nvl(p_organization_id, organization_id)
5984: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
5985: AND concatenated_segments LIKE (p_concatenated_segments )
5986: -- AND concatenated_segments = nvl(p_suggestion, concatenated_segments)

Line 5994: FROM wms_item_locations_kfv

5990: SELECT inventory_location_id,
5991: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5992: locator_segments locsegs,
5993: description
5994: FROM wms_item_locations_kfv
5995: WHERE organization_id = p_organization_id
5996: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
5997: AND concatenated_segments LIKE (p_concatenated_segments )
5998: -- AND alias = nvl(p_alias, alias)

Line 6012: FROM wms_item_locations_kfv a,

6008: SELECT a.inventory_location_id,
6009: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6010: a.locator_segments locsegs,
6011: a.description
6012: FROM wms_item_locations_kfv a,
6013: mtl_secondary_locators b
6014: WHERE b.organization_id = p_Organization_Id
6015: AND b.inventory_item_id = p_Inventory_Item_Id
6016: AND b.subinventory_code = p_Subinventory_Code

Line 6034: FROM wms_item_locations_kfv

6030: SELECT inventory_location_id,
6031: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6032: locator_segments locsegs,
6033: description
6034: FROM wms_item_locations_kfv
6035: WHERE organization_id = Nvl(p_organization_id, organization_id)
6036: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6037: AND concatenated_segments LIKE (p_concatenated_segments )
6038: -- AND concatenated_segments = nvl(p_suggestion, concatenated_segments)

Line 6048: FROM wms_item_locations_kfv

6044: SELECT inventory_location_id,
6045: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6046: locator_segments locsegs,
6047: description
6048: FROM wms_item_locations_kfv
6049: WHERE organization_id = p_organization_id
6050: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6051: AND concatenated_segments LIKE (p_concatenated_segments )
6052: -- AND concatenated_segments = nvl(p_suggestion, concatenated_segments)

Line 6067: FROM wms_item_locations_kfv a,

6063: SELECT a.inventory_location_id,
6064: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6065: a.locator_segments locsegs,
6066: a.description
6067: FROM wms_item_locations_kfv a,
6068: mtl_secondary_locators b
6069: WHERE b.organization_id = p_Organization_Id
6070: AND b.inventory_item_id = p_Inventory_Item_Id
6071: AND b.subinventory_code = p_Subinventory_Code

Line 6088: FROM wms_item_locations_kfv

6084: SELECT inventory_location_id,
6085: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6086: locator_segments locsegs,
6087: description
6088: FROM wms_item_locations_kfv
6089: WHERE organization_id = Nvl(p_organization_id, organization_id)
6090: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6091: AND concatenated_segments LIKE (p_concatenated_segments )
6092: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)

Line 6101: FROM wms_item_locations_kfv

6097: SELECT inventory_location_id,
6098: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6099: locator_segments locsegs,
6100: description
6101: FROM wms_item_locations_kfv
6102: WHERE organization_id = p_organization_id
6103: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6104: AND concatenated_segments LIKE (p_concatenated_segments )
6105: -- AND concatenated_segments = nvl(p_suggestion, concatenated_segments)

Line 6157: FROM wms_item_locations_kfv a,

6153: SELECT a.inventory_location_id,
6154: -- a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6155: a.locator_segments locsegs,
6156: a.description
6157: FROM wms_item_locations_kfv a,
6158: mtl_secondary_locators b
6159: WHERE b.organization_id = p_Organization_Id
6160: AND b.inventory_item_id = p_Inventory_Item_Id
6161: AND b.subinventory_code = p_Subinventory_Code

Line 6176: FROM wms_item_locations_kfv

6172: SELECT inventory_location_id,
6173: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6174: locator_segments locsegs,
6175: description
6176: FROM wms_item_locations_kfv
6177: WHERE organization_id = Nvl(p_organization_id, organization_id)
6178: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6179: AND alias = p_alias
6180: -- AND concatenated_segments = nvl(p_suggestion, concatenated_segments)

Line 6188: FROM wms_item_locations_kfv

6184: SELECT inventory_location_id,
6185: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6186: locator_segments locsegs,
6187: description
6188: FROM wms_item_locations_kfv
6189: WHERE organization_id = p_organization_id
6190: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6191: AND alias = p_alias
6192: ORDER BY 2;

Line 6204: FROM wms_item_locations_kfv a,

6200: SELECT a.inventory_location_id,
6201: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6202: a.locator_segments locsegs,
6203: a.description
6204: FROM wms_item_locations_kfv a,
6205: mtl_secondary_locators b
6206: WHERE b.organization_id = p_Organization_Id
6207: AND b.inventory_item_id = p_Inventory_Item_Id
6208: AND b.subinventory_code = p_Subinventory_Code

Line 6226: FROM wms_item_locations_kfv

6222: SELECT inventory_location_id,
6223: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6224: locator_segments locsegs,
6225: description
6226: FROM wms_item_locations_kfv
6227: WHERE organization_id = Nvl(p_organization_id, organization_id)
6228: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6229: AND alias = p_alias
6230: -- AND concatenated_segments = nvl(p_suggestion, concatenated_segments)

Line 6240: FROM wms_item_locations_kfv

6236: SELECT inventory_location_id,
6237: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6238: locator_segments locsegs,
6239: description
6240: FROM wms_item_locations_kfv
6241: WHERE organization_id = p_organization_id
6242: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6243: AND alias = p_alias
6244: -- AND concatenated_segments = nvl(p_suggestion, concatenated_segments)

Line 6259: FROM wms_item_locations_kfv a,

6255: SELECT a.inventory_location_id,
6256: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6257: a.locator_segments locsegs,
6258: a.description
6259: FROM wms_item_locations_kfv a,
6260: mtl_secondary_locators b
6261: WHERE b.organization_id = p_Organization_Id
6262: AND b.inventory_item_id = p_Inventory_Item_Id
6263: AND b.subinventory_code = p_Subinventory_Code

Line 6280: FROM wms_item_locations_kfv

6276: SELECT inventory_location_id,
6277: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6278: locator_segments locsegs,
6279: description
6280: FROM wms_item_locations_kfv
6281: WHERE organization_id = Nvl(p_organization_id, organization_id)
6282: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6283: AND alias = p_alias
6284: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)

Line 6293: FROM wms_item_locations_kfv

6289: SELECT inventory_location_id,
6290: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6291: locator_segments locsegs,
6292: description
6293: FROM wms_item_locations_kfv
6294: WHERE organization_id = p_organization_id
6295: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6296: AND alias = p_alias
6297: -- AND concatenated_segments = nvl(p_suggestion, concatenated_segments)

Line 6339: FROM wms_item_locations_kfv a,

6335: SELECT a.inventory_location_id,
6336: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6337: a.locator_segments locsegs,
6338: a.description
6339: FROM wms_item_locations_kfv a,
6340: mtl_secondary_locators b
6341: WHERE b.organization_id = p_Organization_Id
6342: AND b.inventory_item_id = nvl(p_Inventory_Item_Id, b.inventory_item_id)
6343: AND b.subinventory_code = p_Subinventory_Code

Line 6357: FROM wms_item_locations_kfv

6353: SELECT inventory_location_id,
6354: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6355: locator_segments locsegs,
6356: description
6357: FROM wms_item_locations_kfv
6358: WHERE organization_id = Nvl(p_organization_id, organization_id)
6359: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6360: AND concatenated_segments LIKE (p_concatenated_segments )
6361: ORDER BY 2;

Line 6368: FROM wms_item_locations_kfv

6364: SELECT inventory_location_id,
6365: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6366: locator_segments locsegs,
6367: description
6368: FROM wms_item_locations_kfv
6369: WHERE organization_id = p_organization_id
6370: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6371: AND concatenated_segments LIKE (p_concatenated_segments )
6372: ORDER BY 2;

Line 6384: FROM wms_item_locations_kfv a,

6380: SELECT a.inventory_location_id,
6381: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6382: a.locator_segments locsegs,
6383: a.description
6384: FROM wms_item_locations_kfv a,
6385: mtl_secondary_locators b
6386: WHERE b.organization_id = p_Organization_Id
6387: AND b.inventory_item_id = nvl(p_Inventory_Item_Id, b.inventory_item_id)
6388: AND b.subinventory_code = p_Subinventory_Code

Line 6405: FROM wms_item_locations_kfv

6401: SELECT inventory_location_id,
6402: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6403: locator_segments locsegs,
6404: description
6405: FROM wms_item_locations_kfv
6406: WHERE organization_id = Nvl(p_organization_id, organization_id)
6407: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6408: AND concatenated_segments LIKE (p_concatenated_segments )
6409: AND project_id = p_project_id

Line 6418: FROM wms_item_locations_kfv

6414: SELECT inventory_location_id,
6415: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6416: locator_segments locsegs,
6417: description
6418: FROM wms_item_locations_kfv
6419: WHERE organization_id = p_organization_id
6420: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6421: AND concatenated_segments LIKE (p_concatenated_segments )
6422: AND project_id = p_project_id

Line 6436: FROM wms_item_locations_kfv a,

6432: SELECT a.inventory_location_id,
6433: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6434: a.locator_segments locsegs,
6435: a.description
6436: FROM wms_item_locations_kfv a,
6437: mtl_secondary_locators b
6438: WHERE b.organization_id = p_Organization_Id
6439: AND b.inventory_item_id = nvl(p_Inventory_Item_Id, b.inventory_item_id)
6440: AND b.subinventory_code = p_Subinventory_Code

Line 6456: FROM wms_item_locations_kfv

6452: SELECT inventory_location_id,
6453: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6454: locator_segments locsegs,
6455: description
6456: FROM wms_item_locations_kfv
6457: WHERE organization_id = Nvl(p_organization_id, organization_id)
6458: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6459: AND concatenated_segments LIKE (p_concatenated_segments )
6460: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)

Line 6468: FROM wms_item_locations_kfv

6464: SELECT inventory_location_id,
6465: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6466: locator_segments locsegs,
6467: description
6468: FROM wms_item_locations_kfv
6469: WHERE organization_id = p_organization_id
6470: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6471: AND concatenated_segments LIKE (p_concatenated_segments )
6472: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)

Line 6522: FROM wms_item_locations_kfv a,

6518: SELECT a.inventory_location_id,
6519: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6520: a.locator_segments locsegs,
6521: a.description
6522: FROM wms_item_locations_kfv a,
6523: mtl_secondary_locators b
6524: WHERE b.organization_id = p_Organization_Id
6525: AND b.inventory_item_id = nvl(p_Inventory_Item_Id, b.inventory_item_id)
6526: AND b.subinventory_code = p_Subinventory_Code

Line 6540: FROM wms_item_locations_kfv

6536: SELECT inventory_location_id,
6537: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6538: locator_segments locsegs,
6539: description
6540: FROM wms_item_locations_kfv
6541: WHERE organization_id = Nvl(p_organization_id, organization_id)
6542: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6543: AND alias = p_alias
6544: ORDER BY 2;

Line 6551: FROM wms_item_locations_kfv

6547: SELECT inventory_location_id,
6548: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6549: locator_segments locsegs,
6550: description
6551: FROM wms_item_locations_kfv
6552: WHERE organization_id = p_organization_id
6553: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6554: AND alias = p_alias
6555: ORDER BY 2;

Line 6567: FROM wms_item_locations_kfv a,

6563: SELECT a.inventory_location_id,
6564: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6565: a.locator_segments locsegs,
6566: a.description
6567: FROM wms_item_locations_kfv a,
6568: mtl_secondary_locators b
6569: WHERE b.organization_id = p_Organization_Id
6570: AND b.inventory_item_id = nvl(p_Inventory_Item_Id, b.inventory_item_id)
6571: AND b.subinventory_code = p_Subinventory_Code

Line 6588: FROM wms_item_locations_kfv

6584: SELECT inventory_location_id,
6585: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6586: locator_segments locsegs,
6587: description
6588: FROM wms_item_locations_kfv
6589: WHERE organization_id = Nvl(p_organization_id, organization_id)
6590: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6591: AND alias = p_alias
6592: AND project_id = p_project_id

Line 6601: FROM wms_item_locations_kfv

6597: SELECT inventory_location_id,
6598: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6599: locator_segments locsegs,
6600: description
6601: FROM wms_item_locations_kfv
6602: WHERE organization_id = p_organization_id
6603: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6604: AND alias = p_alias
6605: AND project_id = p_project_id

Line 6619: FROM wms_item_locations_kfv a,

6615: SELECT a.inventory_location_id,
6616: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6617: a.locator_segments locsegs,
6618: a.description
6619: FROM wms_item_locations_kfv a,
6620: mtl_secondary_locators b
6621: WHERE b.organization_id = p_Organization_Id
6622: AND b.inventory_item_id = nvl(p_Inventory_Item_Id, b.inventory_item_id)
6623: AND b.subinventory_code = p_Subinventory_Code

Line 6639: FROM wms_item_locations_kfv

6635: SELECT inventory_location_id,
6636: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6637: locator_segments locsegs,
6638: description
6639: FROM wms_item_locations_kfv
6640: WHERE organization_id = Nvl(p_organization_id, organization_id)
6641: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6642: AND alias = p_alias
6643: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)

Line 6651: FROM wms_item_locations_kfv

6647: SELECT inventory_location_id,
6648: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6649: locator_segments locsegs,
6650: description
6651: FROM wms_item_locations_kfv
6652: WHERE organization_id = p_organization_id
6653: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6654: AND alias = p_alias
6655: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)

Line 6700: FROM wms_item_locations_kfv

6696: , x_concatenated_segments
6697: , x_description
6698: , x_project_id
6699: , x_task_id
6700: FROM wms_item_locations_kfv
6701: WHERE inventory_location_id = p_inventory_location_id
6702: AND organization_id = p_organization_id;
6703: EXCEPTION
6704: WHEN NO_DATA_FOUND THEN

Line 6753: FROM wms_item_locations_kfv

6749: OPEN x_Locators FOR
6750: SELECT inventory_location_id
6751: , locator_segments locsegs
6752: , description
6753: FROM wms_item_locations_kfv
6754: WHERE organization_id = p_organization_id
6755: AND subinventory_code = NVL(p_Subinventory_Code ,subinventory_code)
6756: AND inventory_location_type = p_inventory_location_type
6757: AND NVL(disable_date, trunc(sysdate+1)) > trunc(sysdate)

Line 6765: FROM wms_item_locations_kfv

6761: OPEN x_Locators FOR
6762: SELECT inventory_location_id
6763: , locator_segments locsegs
6764: , description
6765: FROM wms_item_locations_kfv
6766: WHERE organization_id = p_organization_id
6767: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6768: AND inventory_location_type = p_inventory_location_type
6769: AND NVL(disable_date, trunc(sysdate+1)) > trunc(sysdate)

Line 6813: FROM wms_item_locations_kfv

6809: OPEN x_Locators FOR
6810: SELECT inventory_location_id
6811: , locator_segments locsegs
6812: , description
6813: FROM wms_item_locations_kfv
6814: WHERE organization_id = p_organization_id
6815: AND subinventory_code = NVL(p_Subinventory_Code ,subinventory_code)
6816: AND inventory_location_type = p_inventory_location_type
6817: AND NVL(disable_date, trunc(sysdate+1)) > trunc(sysdate)

Line 6825: FROM wms_item_locations_kfv

6821: OPEN x_Locators FOR
6822: SELECT inventory_location_id
6823: , locator_segments locsegs
6824: , description
6825: FROM wms_item_locations_kfv
6826: WHERE organization_id = p_organization_id
6827: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6828: AND inventory_location_type = p_inventory_location_type
6829: AND NVL(disable_date, trunc(sysdate+1)) > trunc(sysdate)

Line 6857: FROM wms_item_locations_kfv

6853: x_msg_count := 0;
6854:
6855: SELECT locator_segments
6856: INTO x_value
6857: FROM wms_item_locations_kfv
6858: WHERE alias = p_alias
6859: AND organization_id = p_org_id
6860: AND subinventory_code = p_sub_code
6861: AND project_id IS NULL

Line 6872: FROM wms_item_locations_kfv

6868: IF p_suggested IS NOT NULL THEN
6869: BEGIN
6870: SELECT locator_segments
6871: INTO x_value
6872: FROM wms_item_locations_kfv
6873: WHERE alias = p_alias
6874: AND organization_id = p_org_id
6875: AND subinventory_code = p_sub_code
6876: AND locator_segments = p_suggested

Line 6961: FROM wms_item_locations_kfv a,mtl_secondary_locators b

6957: OPEN x_Locators FOR
6958: select a.inventory_location_id,
6959: a.locator_segments concatenated_segments,
6960: nvl( a.description, -1)
6961: FROM wms_item_locations_kfv a,mtl_secondary_locators b
6962: WHERE b.organization_id = p_Organization_Id
6963: AND b.inventory_item_id = p_Inventory_Item_Id
6964: AND nvl(a.disable_date, trunc(sysdate+1)) > trunc(sysdate)
6965: AND b.subinventory_code = p_Subinventory_Code

Line 6975: FROM wms_item_locations_kfv

6971: OPEN x_Locators FOR
6972: select inventory_location_id,
6973: locator_segments concatenated_segments,
6974: description
6975: FROM wms_item_locations_kfv
6976: WHERE organization_id = p_Organization_Id
6977: AND subinventory_code = p_Subinventory_Code
6978: AND nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate)
6979: AND concatenated_segments LIKE (p_concatenated_segments )

Line 6988: FROM wms_item_locations_kfv a,mtl_secondary_locators b

6984: OPEN x_Locators FOR
6985: select a.inventory_location_id,
6986: a.locator_segments concatenated_segments,
6987: nvl( a.description, -1)
6988: FROM wms_item_locations_kfv a,mtl_secondary_locators b
6989: WHERE b.organization_id = p_Organization_Id
6990: AND b.inventory_item_id = p_Inventory_Item_Id
6991: AND nvl(a.disable_date, trunc(sysdate+1)) > trunc(sysdate)
6992: AND b.subinventory_code = p_Subinventory_Code

Line 7003: FROM wms_item_locations_kfv

6999: OPEN x_Locators FOR
7000: select inventory_location_id,
7001: locator_segments concatenated_segments,
7002: description
7003: FROM wms_item_locations_kfv
7004: WHERE organization_id = p_Organization_Id
7005: AND subinventory_code = p_Subinventory_Code
7006: AND nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate)
7007: AND inventory_location_id=NVL(physical_location_id,inventory_location_id)