APPS.WMS_RULE_13 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 269: from MTL_ITEM_LOCATIONS mil

265: ,mil.SUGGESTED_CUBIC_AREA
266: ,mil.SUGGESTED_WEIGHT
267: ,mil.LOCATION_SUGGESTED_UNITS
268: ,mil.rowid
269: from MTL_ITEM_LOCATIONS mil
270: ,MTL_SECONDARY_INVENTORIES msei
271: where mil.organization_id(+) = msei.organization_id
272: and mil.subinventory_code(+) = msei.secondary_inventory_name
273: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 385: from MTL_ITEM_LOCATIONS mil

381: ,mil.SUGGESTED_CUBIC_AREA
382: ,mil.SUGGESTED_WEIGHT
383: ,mil.LOCATION_SUGGESTED_UNITS
384: ,mil.rowid
385: from MTL_ITEM_LOCATIONS mil
386: ,MTL_SECONDARY_INVENTORIES msei
387: where mil.organization_id(+) = msei.organization_id
388: and mil.subinventory_code(+) = msei.secondary_inventory_name
389: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 503: from MTL_ITEM_LOCATIONS mil

499: ,mil.SUGGESTED_CUBIC_AREA
500: ,mil.SUGGESTED_WEIGHT
501: ,mil.LOCATION_SUGGESTED_UNITS
502: ,mil.rowid
503: from MTL_ITEM_LOCATIONS mil
504: ,MTL_SECONDARY_INVENTORIES msei
505: ,MTL_ITEM_SUB_INVENTORIES misi
506: where mil.organization_id(+) = msei.organization_id
507: and mil.subinventory_code(+) = msei.secondary_inventory_name

Line 621: from MTL_ITEM_LOCATIONS mil

617: ,mil.SUGGESTED_CUBIC_AREA
618: ,mil.SUGGESTED_WEIGHT
619: ,mil.LOCATION_SUGGESTED_UNITS
620: ,mil.rowid
621: from MTL_ITEM_LOCATIONS mil
622: ,MTL_SECONDARY_INVENTORIES msei
623: ,MTL_ITEM_SUB_INVENTORIES misi
624: where mil.organization_id(+) = msei.organization_id
625: and mil.subinventory_code(+) = msei.secondary_inventory_name

Line 741: from MTL_ITEM_LOCATIONS mil

737: ,mil.SUGGESTED_CUBIC_AREA
738: ,mil.SUGGESTED_WEIGHT
739: ,mil.LOCATION_SUGGESTED_UNITS
740: ,mil.rowid
741: from MTL_ITEM_LOCATIONS mil
742: ,MTL_SECONDARY_INVENTORIES msei
743: ,MTL_ITEM_SUB_INVENTORIES misi
744: where mil.organization_id(+) = msei.organization_id
745: and mil.subinventory_code(+) = msei.secondary_inventory_name

Line 863: from MTL_ITEM_LOCATIONS mil

859: ,mil.SUGGESTED_CUBIC_AREA
860: ,mil.SUGGESTED_WEIGHT
861: ,mil.LOCATION_SUGGESTED_UNITS
862: ,mil.rowid
863: from MTL_ITEM_LOCATIONS mil
864: ,MTL_SECONDARY_INVENTORIES msei
865: ,MTL_ITEM_SUB_INVENTORIES misi
866: ,MTL_SECONDARY_LOCATORS msl
867: where mil.organization_id = msei.organization_id

Line 986: from MTL_ITEM_LOCATIONS mil

982: ,mil.SUGGESTED_CUBIC_AREA
983: ,mil.SUGGESTED_WEIGHT
984: ,mil.LOCATION_SUGGESTED_UNITS
985: ,mil.rowid
986: from MTL_ITEM_LOCATIONS mil
987: ,MTL_SECONDARY_INVENTORIES msei
988: ,MTL_ITEM_SUB_INVENTORIES misi
989: ,MTL_SECONDARY_LOCATORS msl
990: where mil.organization_id = msei.organization_id

Line 1110: from MTL_ITEM_LOCATIONS mil

1106: ,mil.SUGGESTED_CUBIC_AREA
1107: ,mil.SUGGESTED_WEIGHT
1108: ,mil.LOCATION_SUGGESTED_UNITS
1109: ,mil.rowid
1110: from MTL_ITEM_LOCATIONS mil
1111: ,MTL_SECONDARY_INVENTORIES msei
1112: ,MTL_ITEM_SUB_INVENTORIES misi
1113: ,MTL_SECONDARY_LOCATORS msl
1114: where mil.organization_id = msei.organization_id