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.WMS_RULE_9 dependencies on MTL_SECONDARY_INVENTORIES

Line 156: ,MTL_SECONDARY_INVENTORIES msei

152: ,mil.SUGGESTED_WEIGHT
153: ,mil.LOCATION_SUGGESTED_UNITS
154: ,mil.rowid
155: from MTL_ITEM_LOCATIONS mil
156: ,MTL_SECONDARY_INVENTORIES msei
157: where mil.organization_id(+) = msei.organization_id
158: and mil.subinventory_code(+) = msei.secondary_inventory_name
159: and NVL(msei.disable_date, sysdate+1) > sysdate
160: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 316: ,MTL_SECONDARY_INVENTORIES msei

312: ,mil.SUGGESTED_WEIGHT
313: ,mil.LOCATION_SUGGESTED_UNITS
314: ,mil.rowid
315: from MTL_ITEM_LOCATIONS mil
316: ,MTL_SECONDARY_INVENTORIES msei
317: where mil.organization_id(+) = msei.organization_id
318: and mil.subinventory_code(+) = msei.secondary_inventory_name
319: and NVL(msei.disable_date, sysdate+1) > sysdate
320: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 475: ,MTL_SECONDARY_INVENTORIES msei

471: ,mil.SUGGESTED_WEIGHT
472: ,mil.LOCATION_SUGGESTED_UNITS
473: ,mil.rowid
474: from MTL_ITEM_LOCATIONS mil
475: ,MTL_SECONDARY_INVENTORIES msei
476: where mil.organization_id(+) = msei.organization_id
477: and mil.subinventory_code(+) = msei.secondary_inventory_name
478: and NVL(msei.disable_date, sysdate+1) > sysdate
479: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 636: ,MTL_SECONDARY_INVENTORIES msei

632: ,mil.SUGGESTED_WEIGHT
633: ,mil.LOCATION_SUGGESTED_UNITS
634: ,mil.rowid
635: from MTL_ITEM_LOCATIONS mil
636: ,MTL_SECONDARY_INVENTORIES msei
637: ,MTL_ITEM_SUB_INVENTORIES misi
638: where mil.organization_id(+) = msei.organization_id
639: and mil.subinventory_code(+) = msei.secondary_inventory_name
640: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 797: ,MTL_SECONDARY_INVENTORIES msei

793: ,mil.SUGGESTED_WEIGHT
794: ,mil.LOCATION_SUGGESTED_UNITS
795: ,mil.rowid
796: from MTL_ITEM_LOCATIONS mil
797: ,MTL_SECONDARY_INVENTORIES msei
798: ,MTL_ITEM_SUB_INVENTORIES misi
799: where mil.organization_id(+) = msei.organization_id
800: and mil.subinventory_code(+) = msei.secondary_inventory_name
801: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 960: ,MTL_SECONDARY_INVENTORIES msei

956: ,mil.SUGGESTED_WEIGHT
957: ,mil.LOCATION_SUGGESTED_UNITS
958: ,mil.rowid
959: from MTL_ITEM_LOCATIONS mil
960: ,MTL_SECONDARY_INVENTORIES msei
961: ,MTL_ITEM_SUB_INVENTORIES misi
962: where mil.organization_id(+) = msei.organization_id
963: and mil.subinventory_code(+) = msei.secondary_inventory_name
964: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 1125: ,MTL_SECONDARY_INVENTORIES msei

1121: ,mil.SUGGESTED_WEIGHT
1122: ,mil.LOCATION_SUGGESTED_UNITS
1123: ,mil.rowid
1124: from MTL_ITEM_LOCATIONS mil
1125: ,MTL_SECONDARY_INVENTORIES msei
1126: ,MTL_ITEM_SUB_INVENTORIES misi
1127: ,MTL_SECONDARY_LOCATORS msl
1128: where mil.organization_id = msei.organization_id
1129: and mil.subinventory_code = msei.secondary_inventory_name

Line 1291: ,MTL_SECONDARY_INVENTORIES msei

1287: ,mil.SUGGESTED_WEIGHT
1288: ,mil.LOCATION_SUGGESTED_UNITS
1289: ,mil.rowid
1290: from MTL_ITEM_LOCATIONS mil
1291: ,MTL_SECONDARY_INVENTORIES msei
1292: ,MTL_ITEM_SUB_INVENTORIES misi
1293: ,MTL_SECONDARY_LOCATORS msl
1294: where mil.organization_id = msei.organization_id
1295: and mil.subinventory_code = msei.secondary_inventory_name

Line 1458: ,MTL_SECONDARY_INVENTORIES msei

1454: ,mil.SUGGESTED_WEIGHT
1455: ,mil.LOCATION_SUGGESTED_UNITS
1456: ,mil.rowid
1457: from MTL_ITEM_LOCATIONS mil
1458: ,MTL_SECONDARY_INVENTORIES msei
1459: ,MTL_ITEM_SUB_INVENTORIES misi
1460: ,MTL_SECONDARY_LOCATORS msl
1461: where mil.organization_id = msei.organization_id
1462: and mil.subinventory_code = msei.secondary_inventory_name