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 MTL_SECONDARY_LOCATORS

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 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 960: mtl_secondary_locators b

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
964: AND a.inventory_location_id = b.secondary_locator

Line 1007: mtl_secondary_locators b

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
1011: AND a.inventory_location_id = b.secondary_locator

Line 1094: mtl_secondary_locators b

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
1098: AND a.inventory_location_id = b.secondary_locator

Line 1141: mtl_secondary_locators b

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
1145: AND a.inventory_location_id = b.secondary_locator

Line 3394: FROM mtl_secondary_locators

3390:
3391: IF l_restrict_locators_code = 1 THEN
3392: SELECT COUNT(*)
3393: INTO l_count
3394: FROM mtl_secondary_locators
3395: WHERE p_locator_id = secondary_locator
3396: AND inventory_item_id = l_item_id
3397: AND organization_id = p_orgid;
3398:

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 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 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 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 5088: FROM mtl_secondary_locators

5084: -- check that the locator is allowed
5085: IF (l_restrict_loc = 1) THEN
5086: SELECT COUNT(*)
5087: INTO l_count
5088: FROM mtl_secondary_locators
5089: WHERE organization_id = p_organization_id
5090: AND inventory_item_id = l_item_id
5091: AND subinventory_code = p_subinventory_code
5092: AND secondary_locator = p_locator_id;

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 5964: mtl_secondary_locators b

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
5968: AND a.inventory_location_id = b.secondary_locator

Line 6013: mtl_secondary_locators b

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
6017: AND a.inventory_location_id = b.secondary_locator

Line 6068: mtl_secondary_locators b

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
6072: AND a.inventory_location_id = b.secondary_locator

Line 6158: mtl_secondary_locators b

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
6162: AND a.inventory_location_id = b.secondary_locator

Line 6205: mtl_secondary_locators b

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
6209: AND a.inventory_location_id = b.secondary_locator

Line 6260: mtl_secondary_locators b

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
6264: AND a.inventory_location_id = b.secondary_locator

Line 6340: mtl_secondary_locators b

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
6344: AND a.inventory_location_id = b.secondary_locator

Line 6385: mtl_secondary_locators b

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
6389: AND a.inventory_location_id = b.secondary_locator

Line 6437: mtl_secondary_locators b

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
6441: AND a.inventory_location_id = b.secondary_locator

Line 6523: mtl_secondary_locators b

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
6527: AND a.inventory_location_id = b.secondary_locator

Line 6568: mtl_secondary_locators b

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
6572: AND a.inventory_location_id = b.secondary_locator

Line 6620: mtl_secondary_locators b

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
6624: AND a.inventory_location_id = b.secondary_locator

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 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