APPS.WMS_RULE_10 dependencies on MTL_ITEM_LOCATIONS

Line 153: from MTL_ITEM_LOCATIONS mil

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

Line 280: from MTL_ITEM_LOCATIONS mil

276: ,mil.SUGGESTED_CUBIC_AREA
277: ,mil.SUGGESTED_WEIGHT
278: ,mil.LOCATION_SUGGESTED_UNITS
279: ,mil.rowid
280: from MTL_ITEM_LOCATIONS mil
281: ,MTL_SECONDARY_INVENTORIES msei
282: where mil.organization_id(+) = msei.organization_id
283: and mil.subinventory_code(+) = msei.secondary_inventory_name
284: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 406: from MTL_ITEM_LOCATIONS mil

402: ,mil.SUGGESTED_CUBIC_AREA
403: ,mil.SUGGESTED_WEIGHT
404: ,mil.LOCATION_SUGGESTED_UNITS
405: ,mil.rowid
406: from MTL_ITEM_LOCATIONS mil
407: ,MTL_SECONDARY_INVENTORIES msei
408: where mil.organization_id(+) = msei.organization_id
409: and mil.subinventory_code(+) = msei.secondary_inventory_name
410: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 534: from MTL_ITEM_LOCATIONS mil

530: ,mil.SUGGESTED_CUBIC_AREA
531: ,mil.SUGGESTED_WEIGHT
532: ,mil.LOCATION_SUGGESTED_UNITS
533: ,mil.rowid
534: from MTL_ITEM_LOCATIONS mil
535: ,MTL_SECONDARY_INVENTORIES msei
536: ,MTL_ITEM_SUB_INVENTORIES misi
537: where mil.organization_id(+) = msei.organization_id
538: and mil.subinventory_code(+) = msei.secondary_inventory_name

Line 662: from MTL_ITEM_LOCATIONS mil

658: ,mil.SUGGESTED_CUBIC_AREA
659: ,mil.SUGGESTED_WEIGHT
660: ,mil.LOCATION_SUGGESTED_UNITS
661: ,mil.rowid
662: from MTL_ITEM_LOCATIONS mil
663: ,MTL_SECONDARY_INVENTORIES msei
664: ,MTL_ITEM_SUB_INVENTORIES misi
665: where mil.organization_id(+) = msei.organization_id
666: and mil.subinventory_code(+) = msei.secondary_inventory_name

Line 792: from MTL_ITEM_LOCATIONS mil

788: ,mil.SUGGESTED_CUBIC_AREA
789: ,mil.SUGGESTED_WEIGHT
790: ,mil.LOCATION_SUGGESTED_UNITS
791: ,mil.rowid
792: from MTL_ITEM_LOCATIONS mil
793: ,MTL_SECONDARY_INVENTORIES msei
794: ,MTL_ITEM_SUB_INVENTORIES misi
795: where mil.organization_id(+) = msei.organization_id
796: and mil.subinventory_code(+) = msei.secondary_inventory_name

Line 924: from MTL_ITEM_LOCATIONS mil

920: ,mil.SUGGESTED_CUBIC_AREA
921: ,mil.SUGGESTED_WEIGHT
922: ,mil.LOCATION_SUGGESTED_UNITS
923: ,mil.rowid
924: from MTL_ITEM_LOCATIONS mil
925: ,MTL_SECONDARY_INVENTORIES msei
926: ,MTL_ITEM_SUB_INVENTORIES misi
927: ,MTL_SECONDARY_LOCATORS msl
928: where mil.organization_id = msei.organization_id

Line 1057: from MTL_ITEM_LOCATIONS mil

1053: ,mil.SUGGESTED_CUBIC_AREA
1054: ,mil.SUGGESTED_WEIGHT
1055: ,mil.LOCATION_SUGGESTED_UNITS
1056: ,mil.rowid
1057: from MTL_ITEM_LOCATIONS mil
1058: ,MTL_SECONDARY_INVENTORIES msei
1059: ,MTL_ITEM_SUB_INVENTORIES misi
1060: ,MTL_SECONDARY_LOCATORS msl
1061: where mil.organization_id = msei.organization_id

Line 1191: from MTL_ITEM_LOCATIONS mil

1187: ,mil.SUGGESTED_CUBIC_AREA
1188: ,mil.SUGGESTED_WEIGHT
1189: ,mil.LOCATION_SUGGESTED_UNITS
1190: ,mil.rowid
1191: from MTL_ITEM_LOCATIONS mil
1192: ,MTL_SECONDARY_INVENTORIES msei
1193: ,MTL_ITEM_SUB_INVENTORIES misi
1194: ,MTL_SECONDARY_LOCATORS msl
1195: where mil.organization_id = msei.organization_id