APPS.WMS_RULE_8 dependencies on MTL_ITEM_SUB_INVENTORIES

Line 585: ,MTL_ITEM_SUB_INVENTORIES misi

581: ,mil.LOCATION_SUGGESTED_UNITS
582: ,mil.rowid
583: from MTL_ITEM_LOCATIONS mil
584: ,MTL_SECONDARY_INVENTORIES msei
585: ,MTL_ITEM_SUB_INVENTORIES misi
586: where mil.organization_id(+) = msei.organization_id
587: and mil.subinventory_code(+) = msei.secondary_inventory_name
588: and NVL(msei.disable_date, sysdate+1) > sysdate
589: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 729: ,MTL_ITEM_SUB_INVENTORIES misi

725: ,mil.LOCATION_SUGGESTED_UNITS
726: ,mil.rowid
727: from MTL_ITEM_LOCATIONS mil
728: ,MTL_SECONDARY_INVENTORIES msei
729: ,MTL_ITEM_SUB_INVENTORIES misi
730: where mil.organization_id(+) = msei.organization_id
731: and mil.subinventory_code(+) = msei.secondary_inventory_name
732: and NVL(msei.disable_date, sysdate+1) > sysdate
733: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 875: ,MTL_ITEM_SUB_INVENTORIES misi

871: ,mil.LOCATION_SUGGESTED_UNITS
872: ,mil.rowid
873: from MTL_ITEM_LOCATIONS mil
874: ,MTL_SECONDARY_INVENTORIES msei
875: ,MTL_ITEM_SUB_INVENTORIES misi
876: where mil.organization_id(+) = msei.organization_id
877: and mil.subinventory_code(+) = msei.secondary_inventory_name
878: and NVL(msei.disable_date, sysdate+1) > sysdate
879: and NVL(mil.disable_date, sysdate+1) > sysdate

Line 1023: ,MTL_ITEM_SUB_INVENTORIES misi

1019: ,mil.LOCATION_SUGGESTED_UNITS
1020: ,mil.rowid
1021: from MTL_ITEM_LOCATIONS mil
1022: ,MTL_SECONDARY_INVENTORIES msei
1023: ,MTL_ITEM_SUB_INVENTORIES misi
1024: ,MTL_SECONDARY_LOCATORS msl
1025: where mil.organization_id = msei.organization_id
1026: and mil.subinventory_code = msei.secondary_inventory_name
1027: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 1172: ,MTL_ITEM_SUB_INVENTORIES misi

1168: ,mil.LOCATION_SUGGESTED_UNITS
1169: ,mil.rowid
1170: from MTL_ITEM_LOCATIONS mil
1171: ,MTL_SECONDARY_INVENTORIES msei
1172: ,MTL_ITEM_SUB_INVENTORIES misi
1173: ,MTL_SECONDARY_LOCATORS msl
1174: where mil.organization_id = msei.organization_id
1175: and mil.subinventory_code = msei.secondary_inventory_name
1176: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 1322: ,MTL_ITEM_SUB_INVENTORIES misi

1318: ,mil.LOCATION_SUGGESTED_UNITS
1319: ,mil.rowid
1320: from MTL_ITEM_LOCATIONS mil
1321: ,MTL_SECONDARY_INVENTORIES msei
1322: ,MTL_ITEM_SUB_INVENTORIES misi
1323: ,MTL_SECONDARY_LOCATORS msl
1324: where mil.organization_id = msei.organization_id
1325: and mil.subinventory_code = msei.secondary_inventory_name
1326: and NVL(msei.disable_date, sysdate+1) > sysdate