APPS.WMS_RULE_9 dependencies on MTL_ITEM_LOCATIONS

Line 155: from MTL_ITEM_LOCATIONS mil

151: ,mil.SUGGESTED_CUBIC_AREA
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

Line 315: from MTL_ITEM_LOCATIONS mil

311: ,mil.SUGGESTED_CUBIC_AREA
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

Line 474: from MTL_ITEM_LOCATIONS mil

470: ,mil.SUGGESTED_CUBIC_AREA
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

Line 635: from MTL_ITEM_LOCATIONS mil

631: ,mil.SUGGESTED_CUBIC_AREA
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

Line 796: from MTL_ITEM_LOCATIONS mil

792: ,mil.SUGGESTED_CUBIC_AREA
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

Line 959: from MTL_ITEM_LOCATIONS mil

955: ,mil.SUGGESTED_CUBIC_AREA
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

Line 1124: from MTL_ITEM_LOCATIONS mil

1120: ,mil.SUGGESTED_CUBIC_AREA
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

Line 1290: from MTL_ITEM_LOCATIONS mil

1286: ,mil.SUGGESTED_CUBIC_AREA
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

Line 1457: from MTL_ITEM_LOCATIONS mil

1453: ,mil.SUGGESTED_CUBIC_AREA
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