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

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

Line 673: mtl_secondary_locators b

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

Line 759: mtl_secondary_locators b

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

Line 805: mtl_secondary_locators b

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

Line 2999: FROM mtl_secondary_locators

2995:
2996: IF l_restrict_locators_code = 1 THEN
2997: SELECT COUNT(*)
2998: INTO l_count
2999: FROM mtl_secondary_locators
3000: WHERE p_locator_id = secondary_locator
3001: AND inventory_item_id = l_item_id
3002: AND organization_id = p_orgid;
3003:

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

4627: -- check that the locator is allowed
4628: IF (l_restrict_loc = 1) THEN
4629: SELECT COUNT(*)
4630: INTO l_count
4631: FROM mtl_secondary_locators
4632: WHERE organization_id = p_organization_id
4633: AND inventory_item_id = l_item_id
4634: AND subinventory_code = p_subinventory_code
4635: AND secondary_locator = p_locator_id;

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

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

Line 5540: mtl_secondary_locators b

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

Line 5594: mtl_secondary_locators b

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

Line 5683: mtl_secondary_locators b

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

Line 5729: mtl_secondary_locators b

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

Line 5783: mtl_secondary_locators b

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

Line 5862: mtl_secondary_locators b

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

Line 5906: mtl_secondary_locators b

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

Line 5957: mtl_secondary_locators b

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

Line 6042: mtl_secondary_locators b

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

Line 6086: mtl_secondary_locators b

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

Line 6137: mtl_secondary_locators b

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