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 498: FROM wms_item_locations_kfv a, mtl_secondary_locators b

494: SELECT a.inventory_location_id
495: --, a.concatenated_segments----Bug4398337:Commented this line and added below line
496: , a.locator_segments concatenated_segments
497: , a.description
498: FROM wms_item_locations_kfv a, mtl_secondary_locators b
499: WHERE b.organization_id = p_organization_id
500: AND b.inventory_item_id = p_inventory_item_id
501: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
502: AND b.subinventory_code = p_subinventory_code

Line 513: FROM wms_item_locations_kfv

509: SELECT inventory_location_id
510: -- , concatenated_segments--Bug4398337:Commented this line and added below line
511: , locator_segments concatenated_segments
512: , description
513: FROM wms_item_locations_kfv
514: WHERE organization_id = p_organization_id
515: AND subinventory_code = p_subinventory_code
516: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
517: AND concatenated_segments LIKE (p_concatenated_segments)

Line 564: FROM wms_item_locations_kfv a, mtl_secondary_locators b

560: SELECT a.inventory_location_id
561: --, a.concatenated_segments concatenated_segments--Bug4398337:Commented this line and added below line
562: , a.locator_segments concatenated_segments
563: , a.description
564: FROM wms_item_locations_kfv a, mtl_secondary_locators b
565: WHERE b.organization_id = p_organization_id
566: AND b.inventory_item_id = p_inventory_item_id
567: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
568: AND b.subinventory_code = p_subinventory_code

Line 582: FROM wms_item_locations_kfv

578: SELECT inventory_location_id
579: --, concatenated_segments concatenated_segments--Bug4398337:Commented this line and added below line
580: , locator_segments concatenated_segments
581: , description
582: FROM wms_item_locations_kfv
583: WHERE organization_id = p_organization_id
584: AND subinventory_code = p_subinventory_code
585: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
586: AND concatenated_segments LIKE (p_concatenated_segments)

Line 626: FROM wms_item_locations_kfv a,

622: SELECT a.inventory_location_id,
623: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
624: a.locator_segments locsegs,
625: a.description
626: FROM wms_item_locations_kfv a,
627: mtl_secondary_locators b
628: WHERE b.organization_id = p_Organization_Id
629: AND b.inventory_item_id = p_Inventory_Item_Id
630: AND b.subinventory_code = p_Subinventory_Code

Line 645: FROM wms_item_locations_kfv

641: SELECT inventory_location_id,
642: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
643: locator_segments locsegs,
644: description
645: FROM wms_item_locations_kfv
646: WHERE organization_id = Nvl(p_organization_id, organization_id)
647: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
648: and nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate) /* 2915024 */
649: AND concatenated_segments LIKE (p_concatenated_segments)

Line 657: FROM wms_item_locations_kfv

653: SELECT inventory_location_id,
654: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
655: locator_segments locsegs,
656: description
657: FROM wms_item_locations_kfv
658: WHERE organization_id = p_organization_id
659: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
660: and nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate) /* 2915024 */
661: AND concatenated_segments LIKE (p_concatenated_segments)

Line 672: FROM wms_item_locations_kfv a,

668: SELECT a.inventory_location_id,
669: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
670: a.locator_segments locsegs,
671: a.description
672: FROM wms_item_locations_kfv a,
673: mtl_secondary_locators b
674: WHERE b.organization_id = p_Organization_Id
675: AND b.inventory_item_id = p_Inventory_Item_Id
676: AND b.subinventory_code = p_Subinventory_Code

Line 690: FROM wms_item_locations_kfv

686: SELECT inventory_location_id,
687: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
688: locator_segments locsegs,
689: description
690: FROM wms_item_locations_kfv
691: WHERE organization_id = Nvl(p_organization_id, organization_id)
692: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
693: and nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate) /* 2915024 */
694: AND concatenated_segments LIKE (p_concatenated_segments )

Line 703: FROM wms_item_locations_kfv

699: SELECT inventory_location_id,
700: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
701: locator_segments locsegs,
702: description
703: FROM wms_item_locations_kfv
704: WHERE organization_id = p_organization_id
705: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
706: and nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate) /* 2915024 */
707: AND concatenated_segments LIKE (p_concatenated_segments )

Line 758: FROM wms_item_locations_kfv a,

754: SELECT a.inventory_location_id,
755: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
756: a.locator_segments locsegs,
757: a.description
758: FROM wms_item_locations_kfv a,
759: mtl_secondary_locators b
760: WHERE b.organization_id = p_Organization_Id
761: AND b.inventory_item_id = p_Inventory_Item_Id
762: AND b.subinventory_code = p_Subinventory_Code

Line 777: FROM wms_item_locations_kfv

773: SELECT inventory_location_id,
774: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
775: locator_segments locsegs,
776: description
777: FROM wms_item_locations_kfv
778: WHERE organization_id = Nvl(p_organization_id, organization_id)
779: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
780: and nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate) /* 2915024 */
781: AND alias = p_alias

Line 789: FROM wms_item_locations_kfv

785: SELECT inventory_location_id,
786: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
787: locator_segments locsegs,
788: description
789: FROM wms_item_locations_kfv
790: WHERE organization_id = p_organization_id
791: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
792: and nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate) /* 2915024 */
793: AND alias = p_alias

Line 804: FROM wms_item_locations_kfv a,

800: SELECT a.inventory_location_id,
801: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
802: a.locator_segments locsegs,
803: a.description
804: FROM wms_item_locations_kfv a,
805: mtl_secondary_locators b
806: WHERE b.organization_id = p_Organization_Id
807: AND b.inventory_item_id = p_Inventory_Item_Id
808: AND b.subinventory_code = p_Subinventory_Code

Line 822: FROM wms_item_locations_kfv

818: SELECT inventory_location_id,
819: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
820: locator_segments locsegs,
821: description
822: FROM wms_item_locations_kfv
823: WHERE organization_id = Nvl(p_organization_id, organization_id)
824: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
825: and nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate) /* 2915024 */
826: AND alias = p_alias

Line 835: FROM wms_item_locations_kfv

831: SELECT inventory_location_id,
832: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
833: locator_segments locsegs,
834: description
835: FROM wms_item_locations_kfv
836: WHERE organization_id = p_organization_id
837: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
838: and nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate) /* 2915024 */
839: AND alias = p_alias

Line 870: FROM wms_item_locations_kfv

866: SELECT inventory_location_id
867: , description
868: INTO x_location_id
869: , x_description
870: FROM wms_item_locations_kfv
871: WHERE organization_id = p_org_id
872: AND subinventory_code = p_sub_code
873: AND concatenated_segments = p_concat_segs
874: AND ROWNUM < 2;

Line 902: FROM wms_item_locations_kfv

898: SELECT 'failed'
899: INTO l_validity_check
900: FROM DUAL
901: WHERE EXISTS( SELECT subinventory_code
902: FROM wms_item_locations_kfv
903: WHERE concatenated_segments = p_concat_segs
904: AND p_sub_code <> subinventory_code
905: AND organization_id = p_org_id);
906: EXCEPTION

Line 1080: FROM wms_item_locations_kfv mil

1076: SELECT mil.inventory_location_id
1077: --, mil.concatenated_segments conseg--Bug4398337:Commented this line and added below line
1078: , mil.locator_segments conseg
1079: , mil.description
1080: FROM wms_item_locations_kfv mil
1081: WHERE mil.organization_id = p_organization_id
1082: AND mil.inventory_location_id IN (SELECT from_locator_id
1083: FROM mtl_txn_request_lines
1084: WHERE header_id = p_moheader_id)

Line 1116: FROM wms_item_locations_kfv mil

1112: SELECT mil.inventory_location_id
1113: --, mil.concatenated_segments conseg--Bug4398337:Commented this line and added below line
1114: , mil.locator_segments conseg
1115: , mil.description
1116: FROM wms_item_locations_kfv mil
1117: WHERE mil.organization_id = p_organization_id
1118: AND mil.inventory_location_id IN (SELECT from_locator_id
1119: FROM mtl_txn_request_lines
1120: WHERE header_id = p_moheader_id)

Line 1146: FROM wms_item_locations_kfv mil

1142: SELECT mil.inventory_location_id
1143: --, mil.concatenated_segments consegs--Bug4398337:Commented this line and added below line
1144: , mil.locator_segments consegs
1145: , mil.description
1146: FROM wms_item_locations_kfv mil
1147: WHERE mil.organization_id = p_organization_id
1148: AND inventory_location_id IN (SELECT to_locator_id
1149: FROM mtl_txn_request_lines
1150: WHERE header_id = p_moheader_id)

Line 1178: FROM wms_item_locations_kfv mil, mtl_material_statuses_vl mmsv

1174: , mil.locator_segments concatenated_segments
1175: , mil.description
1176: , mil.status_id
1177: , mmsv.status_code
1178: FROM wms_item_locations_kfv mil, mtl_material_statuses_vl mmsv
1179: WHERE mil.organization_id = p_organization_id
1180: AND mil.subinventory_code = p_subinventory_code
1181: AND mil.concatenated_segments LIKE (p_concatenated_segments)
1182: AND mmsv.status_id = mil.status_id

Line 1217: FROM wms_item_locations_kfv mil, mtl_material_statuses_vl mmsv

1213: , mil.locator_segments concatenated_segments
1214: , mil.description
1215: , mil.status_id
1216: , mmsv.status_code
1217: FROM wms_item_locations_kfv mil, mtl_material_statuses_vl mmsv
1218: WHERE mil.organization_id = p_organization_id
1219: AND mil.subinventory_code = p_subinventory_code
1220: AND mil.alias = p_alias
1221: AND mmsv.status_id = mil.status_id

Line 1913: FROM wms_item_locations_kfv mil, mtl_physical_inventory_tags mpit

1909: SELECT UNIQUE mil.inventory_location_id
1910: --, mil.concatenated_segments--Bug4398337:Commented this line and added below line
1911: , mil.locator_segments concatenated_segments
1912: , mil.description
1913: FROM wms_item_locations_kfv mil, mtl_physical_inventory_tags mpit
1914: WHERE mil.organization_id = p_organization_id
1915: AND mil.subinventory_code = p_subinventory_code
1916: AND mil.concatenated_segments LIKE (p_concatenated_segments)
1917: AND mil.inventory_location_id = mpit.locator_id

Line 1938: FROM wms_item_locations_kfv mil

1934: SELECT inventory_location_id
1935: --, concatenated_segments--Bug4398337:Commented this line and added below line
1936: , locator_segments concatenated_segments
1937: , description
1938: FROM wms_item_locations_kfv mil
1939: WHERE organization_id = p_organization_id
1940: AND subinventory_code = p_subinventory_code
1941: AND concatenated_segments LIKE (p_concatenated_segments)
1942: -- WMS PJM Integration: Restrict Locators based on the project and task

Line 1986: FROM wms_item_locations_kfv mil, mtl_physical_inventory_tags mpit

1982: SELECT UNIQUE mil.inventory_location_id
1983: --, mil.concatenated_segments--Bug4398337:Commented this line and added below line
1984: , mil.locator_segments concatenated_segments
1985: , mil.description
1986: FROM wms_item_locations_kfv mil, mtl_physical_inventory_tags mpit
1987: WHERE mil.organization_id = p_organization_id
1988: AND mil.subinventory_code = p_subinventory_code
1989: AND mil.alias = p_alias
1990: AND mil.inventory_location_id = mpit.locator_id

Line 2011: FROM wms_item_locations_kfv mil

2007: SELECT inventory_location_id
2008: --, concatenated_segments--Bug4398337:Commented this line and added below line
2009: , locator_segments concatenated_segments
2010: , description
2011: FROM wms_item_locations_kfv mil
2012: WHERE organization_id = p_organization_id
2013: AND subinventory_code = p_subinventory_code
2014: AND alias = p_alias
2015: -- WMS PJM Integration: Restrict Locators based on the project and task

Line 2201: FROM wms_item_locations_kfv mil, mtl_cycle_count_entries mcce

2197: SELECT UNIQUE mil.inventory_location_id,
2198: --mil.concatenated_segments concatenated_segments,--Bug4398337:Commented this line and added below line
2199: mil.locator_segments concatenated_segments,
2200: mil.description
2201: FROM wms_item_locations_kfv mil, mtl_cycle_count_entries mcce
2202: WHERE mcce.cycle_count_header_id = p_cycle_count_header_id
2203: AND mil.organization_id = p_organization_id
2204: AND mil.subinventory_code = p_subinventory_code
2205: AND NVL(mil.project_id,-1) = NVL(p_project_id,-1)

Line 2241: FROM wms_item_locations_kfv

2237: SELECT inventory_location_id,
2238: -- concatenated_segments, --Bug4398337:Commented this line and added below line
2239: locator_segments 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

Line 2269: FROM wms_item_locations_kfv

2265: SELECT inventory_location_id,
2266: -- concatenated_segments ,--Bug4398337:Commented this line and added below line
2267: locator_segments 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

Line 2297: FROM wms_item_locations_kfv

2293: SELECT inventory_location_id,
2294: -- concatenated_segments, --Bug4398337:Commented this line and added below line
2295: locator_segments 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

Line 2389: FROM wms_item_locations_kfv mil, mtl_cycle_count_entries mcce

2385: SELECT UNIQUE mil.inventory_location_id,
2386: --mil.concatenated_segments concatenated_segments,--Bug4398337:Commented this line and added below line
2387: mil.locator_segments concatenated_segments,
2388: mil.description
2389: FROM wms_item_locations_kfv mil, mtl_cycle_count_entries mcce
2390: WHERE mcce.cycle_count_header_id = p_cycle_count_header_id
2391: AND mil.organization_id = p_organization_id
2392: AND mil.subinventory_code = p_subinventory_code
2393: AND NVL(mil.project_id,-1) = NVL(p_project_id,-1)

Line 2429: FROM wms_item_locations_kfv

2425: SELECT inventory_location_id,
2426: -- concatenated_segments, --Bug4398337:Commented this line and added below line
2427: locator_segments concatenated_segments,
2428: description
2429: FROM wms_item_locations_kfv
2430: WHERE organization_id = p_organization_id
2431: AND subinventory_code = p_subinventory_code
2432: AND alias = p_alias
2433: AND project_id = p_project_id

Line 2457: FROM wms_item_locations_kfv

2453: SELECT inventory_location_id,
2454: -- concatenated_segments ,--Bug4398337:Commented this line and added below line
2455: locator_segments concatenated_segments,
2456: description
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 || '%')

Line 2486: FROM wms_item_locations_kfv

2482: SELECT inventory_location_id,
2483: -- concatenated_segments, --Bug4398337:Commented this line and added below line
2484: locator_segments concatenated_segments,
2485: description
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 || '%')

Line 3038: FROM wms_item_locations_kfv

3034: SELECT inventory_location_id
3035: --, concatenated_segments--Bug4398337:Commented this line and added below line
3036: , locator_segments concatenated_segments
3037: , description
3038: FROM wms_item_locations_kfv
3039: WHERE organization_id = p_organization_id
3040: AND subinventory_code = p_subinventory_code
3041: AND concatenated_segments LIKE (p_concatenated_segments)
3042: 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 3255: FROM wms_item_locations_kfv mil, MTL_ONHAND_QUANTITIES_DETAIL moq

3251: SELECT moq.locator_id
3252: --, mil.concatenated_segments--Bug4398337:Commented this line and added below line
3253: , mil.locator_segments concatenated_segments
3254: , mil.description
3255: FROM wms_item_locations_kfv mil, MTL_ONHAND_QUANTITIES_DETAIL moq
3256: WHERE mil.concatenated_segments LIKE (p_concatenated_segments)
3257: AND mil.inventory_location_id = moq.locator_id
3258: AND mil.organization_id = p_organization_id
3259: -- Bug 2325664 AND mil.physical_location_id is null -- PJM-WMS Integration

Line 3304: FROM wms_item_locations_kfv mil, MTL_ONHAND_QUANTITIES_DETAIL moq

3300: SELECT moq.locator_id
3301: --, mil.concatenated_segments--Bug4398337:Commented this line and added below line
3302: , mil.locator_segments concatenated_segments
3303: , mil.description
3304: FROM wms_item_locations_kfv mil, MTL_ONHAND_QUANTITIES_DETAIL moq
3305: WHERE alias = p_alias
3306: AND mil.inventory_location_id = moq.locator_id
3307: AND mil.organization_id = p_organization_id
3308: -- Bug 2325664 AND mil.physical_location_id is null -- PJM-WMS Integration

Line 3394: FROM wms_item_locations_kfv milv, mtl_material_statuses_tl mmsv

3390: , milv.locator_segments concatenated_segments
3391: , milv.description
3392: , 0 dummy
3393: , mmsv.status_code
3394: FROM wms_item_locations_kfv milv, mtl_material_statuses_tl mmsv
3395: WHERE milv.organization_id = p_organization_id
3396: AND milv.subinventory_code = p_subinventory_code
3397: AND milv.concatenated_segments LIKE (p_concatenated_segments)
3398: AND (mmsv.status_id(+)/*Added outer join 2918529*/ = milv.status_id )

Line 3438: FROM wms_item_locations_kfv milv, mtl_material_statuses_tl mmsv

3434: , milv.locator_segments concatenated_segments
3435: , milv.description
3436: , 0 dummy
3437: , mmsv.status_code
3438: FROM wms_item_locations_kfv milv, mtl_material_statuses_tl mmsv
3439: WHERE milv.organization_id = p_organization_id
3440: AND milv.subinventory_code = p_subinventory_code
3441: AND milv.alias = p_alias
3442: AND (mmsv.status_id(+)/*Added outer join 2918529*/ = milv.status_id )

Line 3675: FROM wms_item_locations_kfv a,mtl_secondary_locators b

3671: select a.inventory_location_id,
3672: --a.concatenated_segments,--Bug4398337:Commented this line and added below line
3673: a.locator_segments concatenated_segments,
3674: nvl( a.description, -1)
3675: FROM wms_item_locations_kfv a,mtl_secondary_locators b
3676: WHERE b.organization_id = p_Organization_Id
3677: AND b.inventory_item_id = p_Inventory_Item_Id
3678: AND nvl(a.disable_date, trunc(sysdate+1)) > trunc(sysdate)
3679: AND b.subinventory_code = p_Subinventory_Code

Line 3704: FROM wms_item_locations_kfv

3700: select inventory_location_id,
3701: --concatenated_segments,--Bug4398337:Commented this line and added below line
3702: locator_segments concatenated_segments,
3703: description
3704: FROM wms_item_locations_kfv
3705: WHERE organization_id = p_Organization_Id
3706: AND subinventory_code = p_Subinventory_Code
3707: AND nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate)
3708: AND concatenated_segments LIKE (p_concatenated_segments )

Line 3732: FROM wms_item_locations_kfv a,mtl_secondary_locators b

3728: select a.inventory_location_id,
3729: --a.concatenated_segments,--Bug4398337:Commented this line and added below line
3730: a.locator_segments concatenated_segments,
3731: nvl( a.description, -1)
3732: FROM wms_item_locations_kfv a,mtl_secondary_locators b
3733: WHERE b.organization_id = p_Organization_Id
3734: AND b.inventory_item_id = p_Inventory_Item_Id
3735: AND nvl(a.disable_date, trunc(sysdate+1)) > trunc(sysdate)
3736: AND b.subinventory_code = p_Subinventory_Code

Line 3762: FROM wms_item_locations_kfv

3758: select inventory_location_id,
3759: --concatenated_segments,--Bug4398337:Commented this line and added below line
3760: locator_segments concatenated_segments,
3761: description
3762: FROM wms_item_locations_kfv
3763: WHERE organization_id = p_Organization_Id
3764: AND subinventory_code = p_Subinventory_Code
3765: AND nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate)
3766: AND inventory_location_id=NVL(physical_location_id,inventory_location_id)

Line 3858: FROM wms_item_locations_kfv a,mtl_secondary_locators b

3854: select a.inventory_location_id,
3855: --a.concatenated_segments,--Bug4398337:Commented this line and added below line
3856: a.locator_segments concatenated_segments,
3857: nvl( a.description, -1)
3858: FROM wms_item_locations_kfv a,mtl_secondary_locators b
3859: WHERE b.organization_id = p_Organization_Id
3860: AND b.inventory_item_id = p_Inventory_Item_Id
3861: AND nvl(a.disable_date, trunc(sysdate+1)) > trunc(sysdate)
3862: AND b.subinventory_code = p_Subinventory_Code

Line 3888: FROM wms_item_locations_kfv

3884: select inventory_location_id,
3885: --concatenated_segments,--Bug4398337:Commented this line and added below line
3886: locator_segments concatenated_segments,
3887: description
3888: FROM wms_item_locations_kfv
3889: WHERE organization_id = p_Organization_Id
3890: AND subinventory_code = p_Subinventory_Code
3891: AND nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate)
3892: -- AND concatenated_segments LIKE (p_concatenated_segments )

Line 3917: FROM wms_item_locations_kfv a,mtl_secondary_locators b

3913: select a.inventory_location_id,
3914: --a.concatenated_segments,--Bug4398337:Commented this line and added below line
3915: a.locator_segments concatenated_segments,
3916: nvl( a.description, -1)
3917: FROM wms_item_locations_kfv a,mtl_secondary_locators b
3918: WHERE b.organization_id = p_Organization_Id
3919: AND b.inventory_item_id = p_Inventory_Item_Id
3920: AND nvl(a.disable_date, trunc(sysdate+1)) > trunc(sysdate)
3921: AND b.subinventory_code = p_Subinventory_Code

Line 3948: FROM wms_item_locations_kfv

3944: select inventory_location_id,
3945: --concatenated_segments,--Bug4398337:Commented this line and added below line
3946: locator_segments concatenated_segments,
3947: description
3948: FROM wms_item_locations_kfv
3949: WHERE organization_id = p_Organization_Id
3950: AND subinventory_code = p_Subinventory_Code
3951: AND nvl(disable_date, trunc(sysdate+1)) > trunc(sysdate)
3952: AND inventory_location_id=NVL(physical_location_id,inventory_location_id)

Line 4105: FROM wms_item_locations_kfv

4101: SELECT inventory_location_id
4102: --, concatenated_segments--Bug4398337:Commented this line and added below line
4103: , locator_segments concatenated_segments
4104: , description
4105: FROM wms_item_locations_kfv
4106: WHERE organization_id = p_organization_id
4107: AND subinventory_code = p_subinventory_code
4108: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4109: AND concatenated_segments LIKE (p_concatenated_segments)

Line 4148: FROM wms_item_locations_kfv

4144: SELECT inventory_location_id
4145: --, concatenated_segments--Bug4398337:Commented this line and added below line
4146: , locator_segments concatenated_segments
4147: , description
4148: FROM wms_item_locations_kfv
4149: WHERE organization_id = p_organization_id
4150: AND subinventory_code = p_subinventory_code
4151: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4152: AND alias = p_alias

Line 4528: FROM wms_item_locations_kfv

4524: -- , concatenated_segments--Bug4398337:Commented this line and added below line
4525: , locator_segments concatenated_segments
4526: , description
4527: , inventory_location_type
4528: FROM wms_item_locations_kfv
4529: WHERE organization_id = p_organization_id
4530: AND subinventory_code = p_subinventory_code
4531: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4532: AND alias = p_alias

Line 4558: FROM wms_item_locations_kfv

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

Line 4746: FROM wms_item_locations_kfv a, mtl_secondary_locators b

4742: SELECT a.inventory_location_id
4743: --, a.concatenated_segments--Bug4398337:Commented this line and added below line
4744: , a.locator_segments
4745: , NVL(a.description, -1)
4746: FROM wms_item_locations_kfv a, mtl_secondary_locators b
4747: WHERE b.organization_id = p_organization_id
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

Line 4762: FROM wms_item_locations_kfv

4758: SELECT inventory_location_id
4759: --, concatenated_segments--Bug4398337:Commented this line and added below line
4760: , locator_segments concatenated_segments
4761: , description
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)

Line 4779: FROM wms_item_locations_kfv a, mtl_secondary_locators b

4775: SELECT a.inventory_location_id
4776: --, a.concatenated_segments--Bug4398337:Commented this line and added below line
4777: , a.locator_segments concatenated_segments
4778: , NVL(a.description, -1)
4779: FROM wms_item_locations_kfv a, mtl_secondary_locators b
4780: WHERE b.organization_id = p_organization_id
4781: AND b.inventory_item_id = p_inventory_item_id
4782: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4783: AND b.subinventory_code = p_subinventory_code

Line 4795: FROM wms_item_locations_kfv

4791: SELECT inventory_location_id
4792: --, concatenated_segments--Bug4398337:Commented this line and added below line
4793: , locator_segments concatenated_segments
4794: , description
4795: FROM wms_item_locations_kfv
4796: WHERE organization_id = p_organization_id
4797: AND subinventory_code = p_subinventory_code
4798: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4799: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)

Line 4811: FROM wms_item_locations_kfv a, mtl_secondary_locators b

4807: SELECT a.inventory_location_id
4808: --, a.concatenated_segments--Bug4398337:Commented this line and added below line
4809: , a.locator_segments concatenated_segments
4810: , NVL(a.description, -1)
4811: FROM wms_item_locations_kfv a, mtl_secondary_locators b
4812: WHERE b.organization_id = p_organization_id
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

Line 4829: FROM wms_item_locations_kfv

4825: SELECT inventory_location_id
4826: --, concatenated_segments--Bug4398337:Commented this line and added below line
4827: , locator_segments concatenated_segments
4828: , description
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)

Line 4876: FROM wms_item_locations_kfv a, mtl_secondary_locators b

4872: SELECT a.inventory_location_id
4873: --, a.concatenated_segments--Bug4398337:Commented this line and added below line
4874: , a.locator_segments
4875: , NVL(a.description, -1)
4876: FROM wms_item_locations_kfv a, mtl_secondary_locators b
4877: WHERE b.organization_id = p_organization_id
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

Line 4892: FROM wms_item_locations_kfv

4888: SELECT inventory_location_id
4889: --, concatenated_segments--Bug4398337:Commented this line and added below line
4890: , locator_segments concatenated_segments
4891: , description
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)

Line 4909: FROM wms_item_locations_kfv a, mtl_secondary_locators b

4905: SELECT a.inventory_location_id
4906: --, a.concatenated_segments--Bug4398337:Commented this line and added below line
4907: , a.locator_segments concatenated_segments
4908: , NVL(a.description, -1)
4909: FROM wms_item_locations_kfv a, mtl_secondary_locators b
4910: WHERE b.organization_id = p_organization_id
4911: AND b.inventory_item_id = p_inventory_item_id
4912: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4913: AND b.subinventory_code = p_subinventory_code

Line 4925: FROM wms_item_locations_kfv

4921: SELECT inventory_location_id
4922: --, concatenated_segments--Bug4398337:Commented this line and added below line
4923: , locator_segments concatenated_segments
4924: , description
4925: FROM wms_item_locations_kfv
4926: WHERE organization_id = p_organization_id
4927: AND subinventory_code = p_subinventory_code
4928: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
4929: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)

Line 4941: FROM wms_item_locations_kfv a, mtl_secondary_locators b

4937: SELECT a.inventory_location_id
4938: --, a.concatenated_segments--Bug4398337:Commented this line and added below line
4939: , a.locator_segments concatenated_segments
4940: , NVL(a.description, -1)
4941: FROM wms_item_locations_kfv a, mtl_secondary_locators b
4942: WHERE b.organization_id = p_organization_id
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

Line 4959: FROM wms_item_locations_kfv

4955: SELECT inventory_location_id
4956: --, concatenated_segments--Bug4398337:Commented this line and added below line
4957: , locator_segments concatenated_segments
4958: , description
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)

Line 5008: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5004: SELECT a.inventory_location_id
5005: , a.concatenated_segments -- Bug 4398336
5006: --, a.locator_segments concatenated_segments
5007: , NVL(a.description, -1)
5008: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5009: WHERE b.organization_id = p_organization_id
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

Line 5024: FROM wms_item_locations_kfv

5020: SELECT inventory_location_id
5021: , concatenated_segments -- Bug 4398336
5022: --, locator_segments concatenated_segments
5023: , description
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)

Line 5041: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5037: SELECT a.inventory_location_id
5038: , a.concatenated_segments -- Bug 4398336
5039: --, a.locator_segments concatenated_segments
5040: , NVL(a.description, -1)
5041: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5042: WHERE b.organization_id = p_organization_id
5043: AND b.inventory_item_id = p_inventory_item_id
5044: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5045: AND b.subinventory_code = p_subinventory_code

Line 5058: FROM wms_item_locations_kfv

5054: SELECT inventory_location_id
5055: , concatenated_segments -- Bug 4398336
5056: --, locator_segments concatenated_segments
5057: , description
5058: FROM wms_item_locations_kfv
5059: WHERE organization_id = p_organization_id
5060: AND subinventory_code = p_subinventory_code
5061: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5062: -- AND inventory_location_id=nvl(physical_location_id,inventory_location_id)

Line 5075: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5071: SELECT a.inventory_location_id
5072: , a.concatenated_segments -- Bug 4398336
5073: --, a.locator_segments concatenated_segments
5074: , NVL(a.description, -1)
5075: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5076: WHERE b.organization_id = p_organization_id
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

Line 5093: FROM wms_item_locations_kfv

5089: SELECT inventory_location_id
5090: , concatenated_segments -- Bug 4398336
5091: --, locator_segments concatenated_segments
5092: , description
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)

Line 5151: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5147: --, a.concatenated_segments--Bug4398337:Commented this line and added below line
5148: , a.locator_segments concatenated_segments
5149: , NVL(a.description, -1)
5150: , a.subinventory_code
5151: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5152: WHERE b.organization_id = p_organization_id
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

Line 5168: FROM wms_item_locations_kfv

5164: -- , concatenated_segments--Bug4398337:Commented this line and added below line
5165: , locator_segments concatenated_segments
5166: , description
5167: , subinventory_code
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)

Line 5186: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5182: --, a.concatenated_segments--Bug4398337:Commented this line and added below line
5183: , a.locator_segments concatenated_segments
5184: , NVL(a.description, -1)
5185: , a.subinventory_code
5186: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5187: WHERE b.organization_id = p_organization_id
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

Line 5204: FROM wms_item_locations_kfv

5200: -- , concatenated_segments--Bug4398337:Commented this line and added below line
5201: , locator_segments concatenated_segments
5202: , description
5203: , subinventory_code
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)

Line 5222: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5218: --, a.concatenated_segments--Bug4398337:Commented this line and added below line
5219: , a.locator_segments concatenated_segments
5220: , NVL(a.description, -1)
5221: , a.subinventory_code
5222: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5223: WHERE b.organization_id = p_organization_id
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

Line 5241: FROM wms_item_locations_kfv

5237: -- , concatenated_segments--Bug4398337:Commented this line and added below line
5238: , locator_segments concatenated_segments
5239: , description
5240: , subinventory_code
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)

Line 5302: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5298: -- , a.concatenated_segments--Bug4398337:Commented this line and added below line
5299: , a.locator_segments concatenated_segments
5300: , NVL(a.description, -1)
5301: , a.subinventory_code
5302: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5303: WHERE b.organization_id = p_organization_id
5304: AND b.inventory_item_id = p_inventory_item_id
5305: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5306: /*AND b.subinventory_code = p_subinventory_code*/ /*Removed Subinventory restriction, displayes all locs in the org*/

Line 5318: FROM wms_item_locations_kfv

5314: --, concatenated_segments--Bug4398337:Commented this line and added below line
5315: , locator_segments concatenated_segments
5316: , description
5317: , subinventory_code
5318: FROM wms_item_locations_kfv
5319: WHERE organization_id = p_organization_id
5320: /*AND subinventory_code = p_subinventory_code*//*Removed Subinventory restriction, displayes all locs in the org*/
5321: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5322: AND concatenated_segments LIKE (p_concatenated_segments)

Line 5335: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5331: -- , a.concatenated_segments--Bug4398337:Commented this line and added below line
5332: , a.locator_segments concatenated_segments
5333: , NVL(a.description, -1)
5334: ,a.subinventory_code
5335: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5336: WHERE b.organization_id = p_organization_id
5337: AND b.inventory_item_id = p_inventory_item_id
5338: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5339: /*AND b.subinventory_code = p_subinventory_code*//*Removed Subinventory restriction, displayes all locs in the org*/

Line 5352: FROM wms_item_locations_kfv

5348: -- , concatenated_segments--Bug4398337:Commented this line and added below line
5349: , locator_segments concatenated_segments
5350: , description
5351: , subinventory_code
5352: FROM wms_item_locations_kfv
5353: WHERE organization_id = p_organization_id
5354: /*AND subinventory_code = p_subinventory_code*//*Removed Subinventory restriction, displayes all locs in the org*/
5355: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5356: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)

Line 5369: FROM wms_item_locations_kfv a, mtl_secondary_locators b

5365: -- , a.concatenated_segments--Bug4398337:Commented this line and added below line
5366: , a.locator_segments concatenated_segments
5367: , NVL(a.description, -1)
5368: , a.subinventory_code
5369: FROM wms_item_locations_kfv a, mtl_secondary_locators b
5370: WHERE b.organization_id = p_organization_id
5371: AND b.inventory_item_id = p_inventory_item_id
5372: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5373: /*AND b.subinventory_code = p_subinventory_code*//*Removed Subinventory restriction, displayes all locs in the org*/

Line 5387: FROM wms_item_locations_kfv

5383: -- , concatenated_segments--Bug4398337:Commented this line and added below line
5384: , locator_segments concatenated_segments
5385: , description
5386: , subinventory_code
5387: FROM wms_item_locations_kfv
5388: WHERE organization_id = p_organization_id
5389: /*AND subinventory_code = p_subinventory_code*//*Removed Subinventory restriction, displayes all locs in the org*/
5390: AND NVL(disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
5391: AND concatenated_segments LIKE (p_concatenated_segments)

Line 5491: FROM wms_item_locations_kfv a,

5487: SELECT a.inventory_location_id,
5488: -- a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5489: a.locator_segments locsegs,
5490: a.description
5491: FROM wms_item_locations_kfv a,
5492: mtl_secondary_locators b
5493: WHERE b.organization_id = p_Organization_Id
5494: AND b.inventory_item_id = p_Inventory_Item_Id
5495: AND b.subinventory_code = p_Subinventory_Code

Line 5509: FROM wms_item_locations_kfv

5505: SELECT inventory_location_id,
5506: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5507: locator_segments locsegs,
5508: description
5509: FROM wms_item_locations_kfv
5510: WHERE organization_id = Nvl(p_organization_id, organization_id)
5511: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
5512: AND concatenated_segments LIKE (p_concatenated_segments )
5513: -- AND concatenated_segments = nvl(p_suggestion, concatenated_segments)

Line 5521: FROM wms_item_locations_kfv

5517: SELECT inventory_location_id,
5518: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5519: locator_segments locsegs,
5520: description
5521: FROM wms_item_locations_kfv
5522: WHERE organization_id = p_organization_id
5523: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
5524: AND concatenated_segments LIKE (p_concatenated_segments )
5525: -- AND alias = nvl(p_alias, alias)

Line 5539: FROM wms_item_locations_kfv a,

5535: SELECT a.inventory_location_id,
5536: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5537: a.locator_segments locsegs,
5538: a.description
5539: FROM wms_item_locations_kfv a,
5540: mtl_secondary_locators b
5541: WHERE b.organization_id = p_Organization_Id
5542: AND b.inventory_item_id = p_Inventory_Item_Id
5543: AND b.subinventory_code = p_Subinventory_Code

Line 5560: FROM wms_item_locations_kfv

5556: SELECT inventory_location_id,
5557: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5558: locator_segments locsegs,
5559: description
5560: FROM wms_item_locations_kfv
5561: WHERE organization_id = Nvl(p_organization_id, organization_id)
5562: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
5563: AND concatenated_segments LIKE (p_concatenated_segments )
5564: -- AND concatenated_segments = nvl(p_suggestion, concatenated_segments)

Line 5574: FROM wms_item_locations_kfv

5570: SELECT inventory_location_id,
5571: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5572: locator_segments locsegs,
5573: description
5574: FROM wms_item_locations_kfv
5575: WHERE organization_id = p_organization_id
5576: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
5577: AND concatenated_segments LIKE (p_concatenated_segments )
5578: -- AND concatenated_segments = nvl(p_suggestion, concatenated_segments)

Line 5593: FROM wms_item_locations_kfv a,

5589: SELECT a.inventory_location_id,
5590: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5591: a.locator_segments locsegs,
5592: a.description
5593: FROM wms_item_locations_kfv a,
5594: mtl_secondary_locators b
5595: WHERE b.organization_id = p_Organization_Id
5596: AND b.inventory_item_id = p_Inventory_Item_Id
5597: AND b.subinventory_code = p_Subinventory_Code

Line 5613: FROM wms_item_locations_kfv

5609: SELECT inventory_location_id,
5610: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5611: locator_segments locsegs,
5612: description
5613: FROM wms_item_locations_kfv
5614: WHERE organization_id = Nvl(p_organization_id, organization_id)
5615: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
5616: AND concatenated_segments LIKE (p_concatenated_segments )
5617: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)

Line 5626: FROM wms_item_locations_kfv

5622: SELECT inventory_location_id,
5623: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5624: locator_segments locsegs,
5625: description
5626: FROM wms_item_locations_kfv
5627: WHERE organization_id = p_organization_id
5628: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
5629: AND concatenated_segments LIKE (p_concatenated_segments )
5630: -- AND concatenated_segments = nvl(p_suggestion, concatenated_segments)

Line 5682: FROM wms_item_locations_kfv a,

5678: SELECT a.inventory_location_id,
5679: -- a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5680: a.locator_segments locsegs,
5681: a.description
5682: FROM wms_item_locations_kfv a,
5683: mtl_secondary_locators b
5684: WHERE b.organization_id = p_Organization_Id
5685: AND b.inventory_item_id = p_Inventory_Item_Id
5686: AND b.subinventory_code = p_Subinventory_Code

Line 5700: FROM wms_item_locations_kfv

5696: SELECT inventory_location_id,
5697: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5698: locator_segments locsegs,
5699: description
5700: FROM wms_item_locations_kfv
5701: WHERE organization_id = Nvl(p_organization_id, organization_id)
5702: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
5703: AND alias = p_alias
5704: -- AND concatenated_segments = nvl(p_suggestion, concatenated_segments)

Line 5712: FROM wms_item_locations_kfv

5708: SELECT inventory_location_id,
5709: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5710: locator_segments locsegs,
5711: description
5712: FROM wms_item_locations_kfv
5713: WHERE organization_id = p_organization_id
5714: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
5715: AND alias = p_alias
5716: ORDER BY 2;

Line 5728: FROM wms_item_locations_kfv a,

5724: SELECT a.inventory_location_id,
5725: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5726: a.locator_segments locsegs,
5727: a.description
5728: FROM wms_item_locations_kfv a,
5729: mtl_secondary_locators b
5730: WHERE b.organization_id = p_Organization_Id
5731: AND b.inventory_item_id = p_Inventory_Item_Id
5732: AND b.subinventory_code = p_Subinventory_Code

Line 5749: FROM wms_item_locations_kfv

5745: SELECT inventory_location_id,
5746: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5747: locator_segments locsegs,
5748: description
5749: FROM wms_item_locations_kfv
5750: WHERE organization_id = Nvl(p_organization_id, organization_id)
5751: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
5752: AND alias = p_alias
5753: -- AND concatenated_segments = nvl(p_suggestion, concatenated_segments)

Line 5763: FROM wms_item_locations_kfv

5759: SELECT inventory_location_id,
5760: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5761: locator_segments locsegs,
5762: description
5763: FROM wms_item_locations_kfv
5764: WHERE organization_id = p_organization_id
5765: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
5766: AND alias = p_alias
5767: -- AND concatenated_segments = nvl(p_suggestion, concatenated_segments)

Line 5782: FROM wms_item_locations_kfv a,

5778: SELECT a.inventory_location_id,
5779: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5780: a.locator_segments locsegs,
5781: a.description
5782: FROM wms_item_locations_kfv a,
5783: mtl_secondary_locators b
5784: WHERE b.organization_id = p_Organization_Id
5785: AND b.inventory_item_id = p_Inventory_Item_Id
5786: AND b.subinventory_code = p_Subinventory_Code

Line 5802: FROM wms_item_locations_kfv

5798: SELECT inventory_location_id,
5799: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5800: locator_segments locsegs,
5801: description
5802: FROM wms_item_locations_kfv
5803: WHERE organization_id = Nvl(p_organization_id, organization_id)
5804: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
5805: AND alias = p_alias
5806: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)

Line 5815: FROM wms_item_locations_kfv

5811: SELECT inventory_location_id,
5812: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5813: locator_segments locsegs,
5814: description
5815: FROM wms_item_locations_kfv
5816: WHERE organization_id = p_organization_id
5817: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
5818: AND alias = p_alias
5819: -- AND concatenated_segments = nvl(p_suggestion, concatenated_segments)

Line 5861: FROM wms_item_locations_kfv a,

5857: SELECT a.inventory_location_id,
5858: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5859: a.locator_segments locsegs,
5860: a.description
5861: FROM wms_item_locations_kfv a,
5862: mtl_secondary_locators b
5863: WHERE b.organization_id = p_Organization_Id
5864: AND b.inventory_item_id = nvl(p_Inventory_Item_Id, b.inventory_item_id)
5865: AND b.subinventory_code = p_Subinventory_Code

Line 5878: FROM wms_item_locations_kfv

5874: SELECT inventory_location_id,
5875: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5876: locator_segments locsegs,
5877: description
5878: FROM wms_item_locations_kfv
5879: WHERE organization_id = Nvl(p_organization_id, organization_id)
5880: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
5881: AND concatenated_segments LIKE (p_concatenated_segments )
5882: ORDER BY 2;

Line 5889: FROM wms_item_locations_kfv

5885: SELECT inventory_location_id,
5886: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5887: locator_segments locsegs,
5888: description
5889: FROM wms_item_locations_kfv
5890: WHERE organization_id = p_organization_id
5891: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
5892: AND concatenated_segments LIKE (p_concatenated_segments )
5893: ORDER BY 2;

Line 5905: FROM wms_item_locations_kfv a,

5901: SELECT a.inventory_location_id,
5902: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5903: a.locator_segments locsegs,
5904: a.description
5905: FROM wms_item_locations_kfv a,
5906: mtl_secondary_locators b
5907: WHERE b.organization_id = p_Organization_Id
5908: AND b.inventory_item_id = nvl(p_Inventory_Item_Id, b.inventory_item_id)
5909: AND b.subinventory_code = p_Subinventory_Code

Line 5925: FROM wms_item_locations_kfv

5921: SELECT inventory_location_id,
5922: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5923: locator_segments locsegs,
5924: description
5925: FROM wms_item_locations_kfv
5926: WHERE organization_id = Nvl(p_organization_id, organization_id)
5927: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
5928: AND concatenated_segments LIKE (p_concatenated_segments )
5929: AND project_id = p_project_id

Line 5938: FROM wms_item_locations_kfv

5934: SELECT inventory_location_id,
5935: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5936: locator_segments locsegs,
5937: description
5938: FROM wms_item_locations_kfv
5939: WHERE organization_id = p_organization_id
5940: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
5941: AND concatenated_segments LIKE (p_concatenated_segments )
5942: AND project_id = p_project_id

Line 5956: FROM wms_item_locations_kfv a,

5952: SELECT a.inventory_location_id,
5953: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5954: a.locator_segments locsegs,
5955: a.description
5956: FROM wms_item_locations_kfv a,
5957: mtl_secondary_locators b
5958: WHERE b.organization_id = p_Organization_Id
5959: AND b.inventory_item_id = nvl(p_Inventory_Item_Id, b.inventory_item_id)
5960: AND b.subinventory_code = p_Subinventory_Code

Line 5975: FROM wms_item_locations_kfv

5971: SELECT inventory_location_id,
5972: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5973: locator_segments locsegs,
5974: description
5975: FROM wms_item_locations_kfv
5976: WHERE organization_id = Nvl(p_organization_id, organization_id)
5977: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
5978: AND concatenated_segments LIKE (p_concatenated_segments )
5979: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)

Line 5987: FROM wms_item_locations_kfv

5983: SELECT inventory_location_id,
5984: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
5985: locator_segments locsegs,
5986: description
5987: FROM wms_item_locations_kfv
5988: WHERE organization_id = p_organization_id
5989: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
5990: AND concatenated_segments LIKE (p_concatenated_segments )
5991: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)

Line 6041: FROM wms_item_locations_kfv a,

6037: SELECT a.inventory_location_id,
6038: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6039: a.locator_segments locsegs,
6040: a.description
6041: FROM wms_item_locations_kfv a,
6042: mtl_secondary_locators b
6043: WHERE b.organization_id = p_Organization_Id
6044: AND b.inventory_item_id = nvl(p_Inventory_Item_Id, b.inventory_item_id)
6045: AND b.subinventory_code = p_Subinventory_Code

Line 6058: FROM wms_item_locations_kfv

6054: SELECT inventory_location_id,
6055: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6056: locator_segments locsegs,
6057: description
6058: FROM wms_item_locations_kfv
6059: WHERE organization_id = Nvl(p_organization_id, organization_id)
6060: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6061: AND alias = p_alias
6062: ORDER BY 2;

Line 6069: FROM wms_item_locations_kfv

6065: SELECT inventory_location_id,
6066: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6067: locator_segments locsegs,
6068: description
6069: FROM wms_item_locations_kfv
6070: WHERE organization_id = p_organization_id
6071: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6072: AND alias = p_alias
6073: ORDER BY 2;

Line 6085: FROM wms_item_locations_kfv a,

6081: SELECT a.inventory_location_id,
6082: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6083: a.locator_segments locsegs,
6084: a.description
6085: FROM wms_item_locations_kfv a,
6086: mtl_secondary_locators b
6087: WHERE b.organization_id = p_Organization_Id
6088: AND b.inventory_item_id = nvl(p_Inventory_Item_Id, b.inventory_item_id)
6089: AND b.subinventory_code = p_Subinventory_Code

Line 6105: FROM wms_item_locations_kfv

6101: SELECT inventory_location_id,
6102: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6103: locator_segments locsegs,
6104: description
6105: FROM wms_item_locations_kfv
6106: WHERE organization_id = Nvl(p_organization_id, organization_id)
6107: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6108: AND alias = p_alias
6109: AND project_id = p_project_id

Line 6118: FROM wms_item_locations_kfv

6114: SELECT inventory_location_id,
6115: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6116: locator_segments locsegs,
6117: description
6118: FROM wms_item_locations_kfv
6119: WHERE organization_id = p_organization_id
6120: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6121: AND alias = p_alias
6122: AND project_id = p_project_id

Line 6136: FROM wms_item_locations_kfv a,

6132: SELECT a.inventory_location_id,
6133: --a.concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6134: a.locator_segments locsegs,
6135: a.description
6136: FROM wms_item_locations_kfv a,
6137: mtl_secondary_locators b
6138: WHERE b.organization_id = p_Organization_Id
6139: AND b.inventory_item_id = nvl(p_Inventory_Item_Id, b.inventory_item_id)
6140: AND b.subinventory_code = p_Subinventory_Code

Line 6155: FROM wms_item_locations_kfv

6151: SELECT inventory_location_id,
6152: --concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6153: locator_segments locsegs,
6154: description
6155: FROM wms_item_locations_kfv
6156: WHERE organization_id = Nvl(p_organization_id, organization_id)
6157: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6158: AND alias = p_alias
6159: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)

Line 6167: FROM wms_item_locations_kfv

6163: SELECT inventory_location_id,
6164: -- concatenated_segments locsegs,--Bug4398337:Commented this line and added below line
6165: locator_segments locsegs,
6166: description
6167: FROM wms_item_locations_kfv
6168: WHERE organization_id = p_organization_id
6169: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6170: AND alias = p_alias
6171: AND inventory_location_id=nvl(physical_location_id,inventory_location_id)

Line 6215: FROM wms_item_locations_kfv

6211: , x_concatenated_segments
6212: , x_description
6213: , x_project_id
6214: , x_task_id
6215: FROM wms_item_locations_kfv
6216: WHERE inventory_location_id = p_inventory_location_id
6217: AND organization_id = p_organization_id;
6218: EXCEPTION
6219: WHEN NO_DATA_FOUND THEN

Line 6268: FROM wms_item_locations_kfv

6264: OPEN x_Locators FOR
6265: SELECT inventory_location_id
6266: , locator_segments locsegs
6267: , description
6268: FROM wms_item_locations_kfv
6269: WHERE organization_id = p_organization_id
6270: AND subinventory_code = NVL(p_Subinventory_Code ,subinventory_code)
6271: AND inventory_location_type = p_inventory_location_type
6272: AND NVL(disable_date, trunc(sysdate+1)) > trunc(sysdate)

Line 6280: FROM wms_item_locations_kfv

6276: OPEN x_Locators FOR
6277: SELECT inventory_location_id
6278: , locator_segments locsegs
6279: , description
6280: FROM wms_item_locations_kfv
6281: WHERE organization_id = p_organization_id
6282: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6283: AND inventory_location_type = p_inventory_location_type
6284: AND NVL(disable_date, trunc(sysdate+1)) > trunc(sysdate)

Line 6328: FROM wms_item_locations_kfv

6324: OPEN x_Locators FOR
6325: SELECT inventory_location_id
6326: , locator_segments locsegs
6327: , description
6328: FROM wms_item_locations_kfv
6329: WHERE organization_id = p_organization_id
6330: AND subinventory_code = NVL(p_Subinventory_Code ,subinventory_code)
6331: AND inventory_location_type = p_inventory_location_type
6332: AND NVL(disable_date, trunc(sysdate+1)) > trunc(sysdate)

Line 6340: FROM wms_item_locations_kfv

6336: OPEN x_Locators FOR
6337: SELECT inventory_location_id
6338: , locator_segments locsegs
6339: , description
6340: FROM wms_item_locations_kfv
6341: WHERE organization_id = p_organization_id
6342: AND subinventory_code = Nvl(p_Subinventory_Code ,subinventory_code)
6343: AND inventory_location_type = p_inventory_location_type
6344: AND NVL(disable_date, trunc(sysdate+1)) > trunc(sysdate)

Line 6372: FROM wms_item_locations_kfv

6368: x_msg_count := 0;
6369:
6370: SELECT locator_segments
6371: INTO x_value
6372: FROM wms_item_locations_kfv
6373: WHERE alias = p_alias
6374: AND organization_id = p_org_id
6375: AND subinventory_code = p_sub_code
6376: AND project_id IS NULL

Line 6387: FROM wms_item_locations_kfv

6383: IF p_suggested IS NOT NULL THEN
6384: BEGIN
6385: SELECT locator_segments
6386: INTO x_value
6387: FROM wms_item_locations_kfv
6388: WHERE alias = p_alias
6389: AND organization_id = p_org_id
6390: AND subinventory_code = p_sub_code
6391: AND locator_segments = p_suggested