APPS.WMS_RULE_10 dependencies on MTL_ITEM_SUB_INVENTORIES

Line 536: ,MTL_ITEM_SUB_INVENTORIES misi

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

Line 664: ,MTL_ITEM_SUB_INVENTORIES misi

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

Line 794: ,MTL_ITEM_SUB_INVENTORIES misi

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

Line 926: ,MTL_ITEM_SUB_INVENTORIES misi

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

Line 1059: ,MTL_ITEM_SUB_INVENTORIES misi

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

Line 1193: ,MTL_ITEM_SUB_INVENTORIES misi

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