APPS.WMS_RULE_9 dependencies on MTL_ITEM_SUB_INVENTORIES

Line 637: ,MTL_ITEM_SUB_INVENTORIES misi

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
640: and NVL(msei.disable_date, sysdate+1) > sysdate
641: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 798: ,MTL_ITEM_SUB_INVENTORIES misi

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
801: and NVL(msei.disable_date, sysdate+1) > sysdate
802: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 961: ,MTL_ITEM_SUB_INVENTORIES misi

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
964: and NVL(msei.disable_date, sysdate+1) > sysdate
965: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 1126: ,MTL_ITEM_SUB_INVENTORIES misi

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
1129: and mil.subinventory_code = msei.secondary_inventory_name
1130: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 1292: ,MTL_ITEM_SUB_INVENTORIES misi

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
1295: and mil.subinventory_code = msei.secondary_inventory_name
1296: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 1459: ,MTL_ITEM_SUB_INVENTORIES misi

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
1462: and mil.subinventory_code = msei.secondary_inventory_name
1463: and NVL(msei.disable_date, sysdate+1) > sysdate