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 317: from MTL_ITEM_LOCATIONS mil

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

Line 478: from MTL_ITEM_LOCATIONS mil

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

Line 641: from MTL_ITEM_LOCATIONS mil

637: ,mil.SUGGESTED_CUBIC_AREA
638: ,mil.SUGGESTED_WEIGHT
639: ,mil.LOCATION_SUGGESTED_UNITS
640: ,mil.rowid
641: from MTL_ITEM_LOCATIONS mil
642: ,MTL_SECONDARY_INVENTORIES msei
643: ,MTL_ITEM_SUB_INVENTORIES misi
644: where mil.organization_id(+) = msei.organization_id
645: and mil.organization_id=g_organization_id ---bug8425620 8665549

Line 804: from MTL_ITEM_LOCATIONS mil

800: ,mil.SUGGESTED_CUBIC_AREA
801: ,mil.SUGGESTED_WEIGHT
802: ,mil.LOCATION_SUGGESTED_UNITS
803: ,mil.rowid
804: from MTL_ITEM_LOCATIONS mil
805: ,MTL_SECONDARY_INVENTORIES msei
806: ,MTL_ITEM_SUB_INVENTORIES misi
807: where mil.organization_id(+) = msei.organization_id
808: and mil.organization_id=g_organization_id ---bug8425620 8665549

Line 969: from MTL_ITEM_LOCATIONS mil

965: ,mil.SUGGESTED_CUBIC_AREA
966: ,mil.SUGGESTED_WEIGHT
967: ,mil.LOCATION_SUGGESTED_UNITS
968: ,mil.rowid
969: from MTL_ITEM_LOCATIONS mil
970: ,MTL_SECONDARY_INVENTORIES msei
971: ,MTL_ITEM_SUB_INVENTORIES misi
972: where mil.organization_id(+) = msei.organization_id
973: and mil.organization_id=g_organization_id ---bug8425620 8665549

Line 1136: from MTL_ITEM_LOCATIONS mil

1132: ,mil.SUGGESTED_CUBIC_AREA
1133: ,mil.SUGGESTED_WEIGHT
1134: ,mil.LOCATION_SUGGESTED_UNITS
1135: ,mil.rowid
1136: from MTL_ITEM_LOCATIONS mil
1137: ,MTL_SECONDARY_INVENTORIES msei
1138: ,MTL_ITEM_SUB_INVENTORIES misi
1139: ,MTL_SECONDARY_LOCATORS msl
1140: where mil.organization_id = msei.organization_id

Line 1304: from MTL_ITEM_LOCATIONS mil

1300: ,mil.SUGGESTED_CUBIC_AREA
1301: ,mil.SUGGESTED_WEIGHT
1302: ,mil.LOCATION_SUGGESTED_UNITS
1303: ,mil.rowid
1304: from MTL_ITEM_LOCATIONS mil
1305: ,MTL_SECONDARY_INVENTORIES msei
1306: ,MTL_ITEM_SUB_INVENTORIES misi
1307: ,MTL_SECONDARY_LOCATORS msl
1308: where mil.organization_id = msei.organization_id

Line 1473: from MTL_ITEM_LOCATIONS mil

1469: ,mil.SUGGESTED_CUBIC_AREA
1470: ,mil.SUGGESTED_WEIGHT
1471: ,mil.LOCATION_SUGGESTED_UNITS
1472: ,mil.rowid
1473: from MTL_ITEM_LOCATIONS mil
1474: ,MTL_SECONDARY_INVENTORIES msei
1475: ,MTL_ITEM_SUB_INVENTORIES misi
1476: ,MTL_SECONDARY_LOCATORS msl
1477: where mil.organization_id = msei.organization_id