APPS.WMS_RULE_9 dependencies on MTL_ITEM_SUB_INVENTORIES

Line 643: ,MTL_ITEM_SUB_INVENTORIES misi

639: ,mil.LOCATION_SUGGESTED_UNITS
640: ,mil.rowid
641: from MTL_ITEM_LOCATIONS mil
642: ,MTL_SECONDARY_INVENTORIES msei
643: ,MTL_ITEM_SUB_INVENTORIES misi
644: where mil.organization_id(+) = msei.organization_id
645: and mil.organization_id=g_organization_id ---bug8425620 8665549
646: and mil.subinventory_code(+) = msei.secondary_inventory_name
647: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 806: ,MTL_ITEM_SUB_INVENTORIES misi

802: ,mil.LOCATION_SUGGESTED_UNITS
803: ,mil.rowid
804: from MTL_ITEM_LOCATIONS mil
805: ,MTL_SECONDARY_INVENTORIES msei
806: ,MTL_ITEM_SUB_INVENTORIES misi
807: where mil.organization_id(+) = msei.organization_id
808: and mil.organization_id=g_organization_id ---bug8425620 8665549
809: and mil.subinventory_code(+) = msei.secondary_inventory_name
810: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 971: ,MTL_ITEM_SUB_INVENTORIES misi

967: ,mil.LOCATION_SUGGESTED_UNITS
968: ,mil.rowid
969: from MTL_ITEM_LOCATIONS mil
970: ,MTL_SECONDARY_INVENTORIES msei
971: ,MTL_ITEM_SUB_INVENTORIES misi
972: where mil.organization_id(+) = msei.organization_id
973: and mil.organization_id=g_organization_id ---bug8425620 8665549
974: and mil.subinventory_code(+) = msei.secondary_inventory_name
975: and NVL(msei.disable_date, sysdate+1) > sysdate

Line 1138: ,MTL_ITEM_SUB_INVENTORIES misi

1134: ,mil.LOCATION_SUGGESTED_UNITS
1135: ,mil.rowid
1136: from MTL_ITEM_LOCATIONS mil
1137: ,MTL_SECONDARY_INVENTORIES msei
1138: ,MTL_ITEM_SUB_INVENTORIES misi
1139: ,MTL_SECONDARY_LOCATORS msl
1140: where mil.organization_id = msei.organization_id
1141: and mil.organization_id=g_organization_id ---bug8425620 8665549
1142: and mil.subinventory_code = msei.secondary_inventory_name

Line 1306: ,MTL_ITEM_SUB_INVENTORIES misi

1302: ,mil.LOCATION_SUGGESTED_UNITS
1303: ,mil.rowid
1304: from MTL_ITEM_LOCATIONS mil
1305: ,MTL_SECONDARY_INVENTORIES msei
1306: ,MTL_ITEM_SUB_INVENTORIES misi
1307: ,MTL_SECONDARY_LOCATORS msl
1308: where mil.organization_id = msei.organization_id
1309: and mil.organization_id=g_organization_id ---bug8425620 8665549
1310: and mil.subinventory_code = msei.secondary_inventory_name

Line 1475: ,MTL_ITEM_SUB_INVENTORIES misi

1471: ,mil.LOCATION_SUGGESTED_UNITS
1472: ,mil.rowid
1473: from MTL_ITEM_LOCATIONS mil
1474: ,MTL_SECONDARY_INVENTORIES msei
1475: ,MTL_ITEM_SUB_INVENTORIES misi
1476: ,MTL_SECONDARY_LOCATORS msl
1477: where mil.organization_id = msei.organization_id
1478: and mil.organization_id=g_organization_id ---bug8425620 8665549
1479: and mil.subinventory_code = msei.secondary_inventory_name