APPS.WMS_RULE_7 dependencies on MTL_ITEM_LOCATIONS

Line 152: from MTL_ITEM_LOCATIONS mil

148: ,mil.SUGGESTED_CUBIC_AREA
149: ,mil.SUGGESTED_WEIGHT
150: ,mil.LOCATION_SUGGESTED_UNITS
151: ,mil.rowid
152: from MTL_ITEM_LOCATIONS mil
153: ,MTL_SECONDARY_INVENTORIES msei
154: where mil.organization_id(+) = msei.organization_id
155: and mil.subinventory_code(+) = msei.secondary_inventory_name
156: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 276: from MTL_ITEM_LOCATIONS mil

272: ,mil.SUGGESTED_CUBIC_AREA
273: ,mil.SUGGESTED_WEIGHT
274: ,mil.LOCATION_SUGGESTED_UNITS
275: ,mil.rowid
276: from MTL_ITEM_LOCATIONS mil
277: ,MTL_SECONDARY_INVENTORIES msei
278: where mil.organization_id(+) = msei.organization_id
279: and mil.subinventory_code(+) = msei.secondary_inventory_name
280: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 399: from MTL_ITEM_LOCATIONS mil

395: ,mil.SUGGESTED_CUBIC_AREA
396: ,mil.SUGGESTED_WEIGHT
397: ,mil.LOCATION_SUGGESTED_UNITS
398: ,mil.rowid
399: from MTL_ITEM_LOCATIONS mil
400: ,MTL_SECONDARY_INVENTORIES msei
401: where mil.organization_id(+) = msei.organization_id
402: and mil.subinventory_code(+) = msei.secondary_inventory_name
403: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 524: from MTL_ITEM_LOCATIONS mil

520: ,mil.SUGGESTED_CUBIC_AREA
521: ,mil.SUGGESTED_WEIGHT
522: ,mil.LOCATION_SUGGESTED_UNITS
523: ,mil.rowid
524: from MTL_ITEM_LOCATIONS mil
525: ,MTL_SECONDARY_INVENTORIES msei
526: ,MTL_ITEM_SUB_INVENTORIES misi
527: where mil.organization_id(+) = msei.organization_id
528: and mil.subinventory_code(+) = msei.secondary_inventory_name

Line 649: from MTL_ITEM_LOCATIONS mil

645: ,mil.SUGGESTED_CUBIC_AREA
646: ,mil.SUGGESTED_WEIGHT
647: ,mil.LOCATION_SUGGESTED_UNITS
648: ,mil.rowid
649: from MTL_ITEM_LOCATIONS mil
650: ,MTL_SECONDARY_INVENTORIES msei
651: ,MTL_ITEM_SUB_INVENTORIES misi
652: where mil.organization_id(+) = msei.organization_id
653: and mil.subinventory_code(+) = msei.secondary_inventory_name

Line 776: from MTL_ITEM_LOCATIONS mil

772: ,mil.SUGGESTED_CUBIC_AREA
773: ,mil.SUGGESTED_WEIGHT
774: ,mil.LOCATION_SUGGESTED_UNITS
775: ,mil.rowid
776: from MTL_ITEM_LOCATIONS mil
777: ,MTL_SECONDARY_INVENTORIES msei
778: ,MTL_ITEM_SUB_INVENTORIES misi
779: where mil.organization_id(+) = msei.organization_id
780: and mil.subinventory_code(+) = msei.secondary_inventory_name

Line 905: from MTL_ITEM_LOCATIONS mil

901: ,mil.SUGGESTED_CUBIC_AREA
902: ,mil.SUGGESTED_WEIGHT
903: ,mil.LOCATION_SUGGESTED_UNITS
904: ,mil.rowid
905: from MTL_ITEM_LOCATIONS mil
906: ,MTL_SECONDARY_INVENTORIES msei
907: ,MTL_ITEM_SUB_INVENTORIES misi
908: ,MTL_SECONDARY_LOCATORS msl
909: where mil.organization_id = msei.organization_id

Line 1035: from MTL_ITEM_LOCATIONS mil

1031: ,mil.SUGGESTED_CUBIC_AREA
1032: ,mil.SUGGESTED_WEIGHT
1033: ,mil.LOCATION_SUGGESTED_UNITS
1034: ,mil.rowid
1035: from MTL_ITEM_LOCATIONS mil
1036: ,MTL_SECONDARY_INVENTORIES msei
1037: ,MTL_ITEM_SUB_INVENTORIES misi
1038: ,MTL_SECONDARY_LOCATORS msl
1039: where mil.organization_id = msei.organization_id

Line 1166: from MTL_ITEM_LOCATIONS mil

1162: ,mil.SUGGESTED_CUBIC_AREA
1163: ,mil.SUGGESTED_WEIGHT
1164: ,mil.LOCATION_SUGGESTED_UNITS
1165: ,mil.rowid
1166: from MTL_ITEM_LOCATIONS mil
1167: ,MTL_SECONDARY_INVENTORIES msei
1168: ,MTL_ITEM_SUB_INVENTORIES misi
1169: ,MTL_SECONDARY_LOCATORS msl
1170: where mil.organization_id = msei.organization_id